If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Ideas on how to start
hi,
I have already my database I just want to ask and suggestion or idea or sample downloads for access 2003 that generates invoice no let say if a customer orders again access will give an invoice no for his new order.. so that i can monitor the customer orders from this invoice no. thanks for any help i really appreciate |
#2
|
|||
|
|||
Ideas on how to start
Is there a problem using the Autonumber? If you want something with more
control, Roger Carlson has a small sample database for generating consecutive numbers on his site www.rogersaccesslibrary.com. -- Duane Hookom Microsoft Access MVP "Revned" wrote: hi, I have already my database I just want to ask and suggestion or idea or sample downloads for access 2003 that generates invoice no let say if a customer orders again access will give an invoice no for his new order.. so that i can monitor the customer orders from this invoice no. thanks for any help i really appreciate |
#3
|
|||
|
|||
Ideas on how to start
yes im starting doing it using autonumber but as my customer orders 5 items
it generates 5 unique numbers also... what i want is just one unique number for this 5 orders, can you help me on this? can you send to me the exact link i can not find which sample your are refering to from rogersacceslibrary... thanks Duabe Hookom it really appreciate... "Duane Hookom" wrote: Is there a problem using the Autonumber? If you want something with more control, Roger Carlson has a small sample database for generating consecutive numbers on his site www.rogersaccesslibrary.com. -- Duane Hookom Microsoft Access MVP "Revned" wrote: hi, I have already my database I just want to ask and suggestion or idea or sample downloads for access 2003 that generates invoice no let say if a customer orders again access will give an invoice no for his new order.. so that i can monitor the customer orders from this invoice no. thanks for any help i really appreciate |
#4
|
|||
|
|||
Ideas on how to start
Your tables should look something like:
TblInvoice InvoiceID InvoiceNumber InvoiceDate CustomerID TblInvoiceDetail InvoiceDetailID InvoiceID ItemID Quantity ItemPrice With these tables you can enter multiple items on the same invoice. For a new invoice, you can use the following expression to have Access automatically generate the invoice number: DMax("[InvoiceNumber]","TblInvoiceNumber") + 1 Steve "Revned" wrote in message ... hi, I have already my database I just want to ask and suggestion or idea or sample downloads for access 2003 that generates invoice no let say if a customer orders again access will give an invoice no for his new order.. so that i can monitor the customer orders from this invoice no. thanks for any help i really appreciate |
#5
|
|||
|
|||
Ideas on how to start
Steve has a solution in this thread. One unique number on a main form can be
passed to a subform using the Link Master/Child properties of the subform. -- Duane Hookom Microsoft Access MVP "Revned" wrote: yes im starting doing it using autonumber but as my customer orders 5 items it generates 5 unique numbers also... what i want is just one unique number for this 5 orders, can you help me on this? can you send to me the exact link i can not find which sample your are refering to from rogersacceslibrary... thanks Duabe Hookom it really appreciate... "Duane Hookom" wrote: Is there a problem using the Autonumber? If you want something with more control, Roger Carlson has a small sample database for generating consecutive numbers on his site www.rogersaccesslibrary.com. -- Duane Hookom Microsoft Access MVP "Revned" wrote: hi, I have already my database I just want to ask and suggestion or idea or sample downloads for access 2003 that generates invoice no let say if a customer orders again access will give an invoice no for his new order.. so that i can monitor the customer orders from this invoice no. thanks for any help i really appreciate |
#6
|
|||
|
|||
Ideas on how to start
thank you Steve and Duane Hookom
i really appreciate "Steve" wrote: Your tables should look something like: TblInvoice InvoiceID InvoiceNumber InvoiceDate CustomerID TblInvoiceDetail InvoiceDetailID InvoiceID ItemID Quantity ItemPrice With these tables you can enter multiple items on the same invoice. For a new invoice, you can use the following expression to have Access automatically generate the invoice number: DMax("[InvoiceNumber]","TblInvoiceNumber") + 1 Steve "Revned" wrote in message ... hi, I have already my database I just want to ask and suggestion or idea or sample downloads for access 2003 that generates invoice no let say if a customer orders again access will give an invoice no for his new order.. so that i can monitor the customer orders from this invoice no. thanks for any help i really appreciate |
#7
|
|||
|
|||
Ideas on how to start
one more thing steve
may know the properties of each field and where do i write the Dmax function thanks again "Revned" wrote: thank you Steve and Duane Hookom i really appreciate "Steve" wrote: Your tables should look something like: TblInvoice InvoiceID InvoiceNumber InvoiceDate CustomerID TblInvoiceDetail InvoiceDetailID InvoiceID ItemID Quantity ItemPrice With these tables you can enter multiple items on the same invoice. For a new invoice, you can use the following expression to have Access automatically generate the invoice number: DMax("[InvoiceNumber]","TblInvoiceNumber") + 1 Steve "Revned" wrote in message ... hi, I have already my database I just want to ask and suggestion or idea or sample downloads for access 2003 that generates invoice no let say if a customer orders again access will give an invoice no for his new order.. so that i can monitor the customer orders from this invoice no. thanks for any help i really appreciate |
#8
|
|||
|
|||
Ideas on how to start
Open your invoice form in design view and select the InvoiceNumber textbox.
Open properties and go to the Data tab. Put the DMax function in the Default Value property. Close properties and close your form. When you go to a new invoice record and enter data in any other field then prrss enter, go to another field, go to a different record or close the form, Access will automatically create the new invoice number. Steve "Revned" wrote in message ... one more thing steve may know the properties of each field and where do i write the Dmax function thanks again "Revned" wrote: thank you Steve and Duane Hookom i really appreciate "Steve" wrote: Your tables should look something like: TblInvoice InvoiceID InvoiceNumber InvoiceDate CustomerID TblInvoiceDetail InvoiceDetailID InvoiceID ItemID Quantity ItemPrice With these tables you can enter multiple items on the same invoice. For a new invoice, you can use the following expression to have Access automatically generate the invoice number: DMax("[InvoiceNumber]","TblInvoiceNumber") + 1 Steve "Revned" wrote in message ... hi, I have already my database I just want to ask and suggestion or idea or sample downloads for access 2003 that generates invoice no let say if a customer orders again access will give an invoice no for his new order.. so that i can monitor the customer orders from this invoice no. thanks for any help i really appreciate |
#9
|
|||
|
|||
Ideas on how to start
i am planning to create a cmdNewOrder button rather that closing the form or
pressing enter.. let say when i open my Order Forms i will just click on that button and access will clear my subform where i place my order item and generate new Invoice is that a right way maybe not the best way but easy and not completed hopefully what can you advise thanks anyway "Steve" wrote: Open your invoice form in design view and select the InvoiceNumber textbox. Open properties and go to the Data tab. Put the DMax function in the Default Value property. Close properties and close your form. When you go to a new invoice record and enter data in any other field then prrss enter, go to another field, go to a different record or close the form, Access will automatically create the new invoice number. Steve "Revned" wrote in message ... one more thing steve may know the properties of each field and where do i write the Dmax function thanks again "Revned" wrote: thank you Steve and Duane Hookom i really appreciate "Steve" wrote: Your tables should look something like: TblInvoice InvoiceID InvoiceNumber InvoiceDate CustomerID TblInvoiceDetail InvoiceDetailID InvoiceID ItemID Quantity ItemPrice With these tables you can enter multiple items on the same invoice. For a new invoice, you can use the following expression to have Access automatically generate the invoice number: DMax("[InvoiceNumber]","TblInvoiceNumber") + 1 Steve "Revned" wrote in message ... hi, I have already my database I just want to ask and suggestion or idea or sample downloads for access 2003 that generates invoice no let say if a customer orders again access will give an invoice no for his new order.. so that i can monitor the customer orders from this invoice no. thanks for any help i really appreciate |
#10
|
|||
|
|||
Ideas on how to start
You don't to create the button! Just go to the navigation buttons at the
bottom left of the screen and click the new record button. In my previous response I said ... When you go to a new invoice record and enter data in any other field then press enter, go to another field, go to a different record or close the form, Access will automatically create the new invoice number. When you do any of those four actions, Access saves the current record and with the DMax function in the default value of InvoiceNumber will automatically create the new invoice number. Steve "Revned" wrote in message ... i am planning to create a cmdNewOrder button rather that closing the form or pressing enter.. let say when i open my Order Forms i will just click on that button and access will clear my subform where i place my order item and generate new Invoice is that a right way maybe not the best way but easy and not completed hopefully what can you advise thanks anyway "Steve" wrote: Open your invoice form in design view and select the InvoiceNumber textbox. Open properties and go to the Data tab. Put the DMax function in the Default Value property. Close properties and close your form. When you go to a new invoice record and enter data in any other field then prrss enter, go to another field, go to a different record or close the form, Access will automatically create the new invoice number. Steve "Revned" wrote in message ... one more thing steve may know the properties of each field and where do i write the Dmax function thanks again "Revned" wrote: thank you Steve and Duane Hookom i really appreciate "Steve" wrote: Your tables should look something like: TblInvoice InvoiceID InvoiceNumber InvoiceDate CustomerID TblInvoiceDetail InvoiceDetailID InvoiceID ItemID Quantity ItemPrice With these tables you can enter multiple items on the same invoice. For a new invoice, you can use the following expression to have Access automatically generate the invoice number: DMax("[InvoiceNumber]","TblInvoiceNumber") + 1 Steve "Revned" wrote in message ... hi, I have already my database I just want to ask and suggestion or idea or sample downloads for access 2003 that generates invoice no let say if a customer orders again access will give an invoice no for his new order.. so that i can monitor the customer orders from this invoice no. thanks for any help i really appreciate |
Thread Tools | |
Display Modes | |
|
|