separate a form by months

[jzwp11]

You will have to use a main form with a subform. The main form should be based on tblLoadInvoices. You will need combo boxes to populate both the fkLoadID and the fkInvoiceID. You will have to create the load and invoice records before going to this form. The subform will be based on tblloadinvoicedetail. You will have to use combo boxes to supply values for the fkEmployeeID and fkItemID. You can populate the price field by bringing the correct price with the item combo box. Also, I just noticed that you have the load invoice date in the detail table. That is incorrect, it should be in tblLoadInvoices.

The form for entering invoices should be relatively simple. It should be based on tblInvoice and combo boxes should be used to populate the customer and price type fields. I don't see an invoice number field in that table. I assume that you have one, so you should probably add that field to the table. For the load information, you will need another form/subform setup with the main form being based on tblDays with a subform being based on tblLoads. On that subform, you will need a combo box to populate the employee (driver).



Give the forms a try, and let us know if you have any questions or problems.

[graciemora]

the load and invoice records,? I already have a field with loads numbers, because I use the same loads numbers depending in dayload, but the invoices are records that change constantly..

Do I have to work with differents forms everyday, Instead of one.
I believed I could do everything in one form. this is harder that i believed. sorry I do not want you to think that I am not reading, but is so confuse, the book I have only give me examples with forms and subforms coming from one table. that's why I created tbltransaction, I know I can create a form coming from differnt tables or queries, but..
when I added the combo boxes to supply values is giving me the ID number instead of values or data. why, I do not see an option on property sheet, I tried row source but still is giving me ID's.
thanks for your patient,

[jzwp11]

...the load and invoice records,? I already have a field with loads numbers,

Yes, you have the fields but you have to create the records (the actual data held in the fields in the table)

combo boxes to supply values is giving me the ID number instead of values or data. why, I do not see an option on property sheet, I tried row source but still is giving me ID's

Actually you need the column widths property (format tab). I've attached a Word document that explains some of the combo box properties (later part of the document). I've also included the database that is used in the Word document.

Do I have to work with differents forms everyday, Instead of one.

You can use a main form with subforms to some extent to try to get things in one form. The invoices however may require either a separate form or some code integrated into another form. Doing the code would be much more involved than creating a simple form. You can actually set a little menu system to direct your users to the right form based on what they want to do.

[graciemora]

hi ! I been really busy and I could not work and the forms but I am back trying to learn more.
I have the forms and I have some questions
1. the main form based tbl Load Invoices. I created the combo boxes and hide the ID fields.
2. I do not have invoice records because I obtain that information while I am seeing the invoices.(every day) I need to file it up while I am doing data entry
What control should I use for that?
3.if I use combo boxes for curr price and I stored and item field change the Item depending on the price!
and I have more questions but I want to go slow this time. thanks for your time and I appreciate your time.

[jzwp11]

Typically I would use a combo box to supply the invoice numbers and if the invoice number does not already exist, I would use some code in the On Not in List event of the combo box that will open up a form to add a new invoice number. When you have completed the invoice record, you will go back to where you left off in the original form. That is the best approach when you are working with both existing and new invoices, but are your invoices ALWAYS new invoice numbers? If so, we might handle that a little differently since you would never be looking for existing invoice numbers.

Getting the right price to show up (for your item #3) will depend on the invoice since we had the price type field in that table. So, getting the right price to show up will require some coordination with the invoice information, but I need to know answer the question above before I know how to proceed with the price.

[graciemora]

Yes, every day I will have new invoices,

[jzwp11]

Will you also have existing invoices in addition to the new invoices?

[graciemora]

yes, I will need to add some invoice numbers from the last 3 months.

[jzwp11]

Since some coding is required, I can provide the general code in my next post, but then you'll have to adapt it to your database. Alternatively, if you prefer, I can write the code directly into your database if you provide a current copy of it.

[graciemora]

Since some coding is required, I can provide the general code in my next post, but then you'll have to adapt it to your database. Alternatively, if you prefer, I can write the code directly into your database if you provide a current copy of it.

Can you guide me thru this process. Do I still need the tblinvoice?
the form should work something like using lookups for:
tblloads
tblemployee(revise by)
tblitems
tblprice
tblreasoncodes
tblemployees(Drivername)
tblemployees (checkby: WH)
I taught we can just add invoice numbers to the form with out using combo boxes, just adding them to the form. and tbl invoices will populate with that information. thanks

[jzwp11]

Do I still need the tblinvoice?

yes

I taught we can just add invoice numbers to the form with out using combo boxes, just adding them to the form. and tbl invoices will populate with that information.

Since you have other information in addition to the invoice number (customer and price type) we need some way of capturing all of the information. We really need the price type in order to get the correct price for the items being delivered.

Since you have probably made changes over the past few weeks, can you post your database so that I can see what you have done?