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 said:
one more thing steve
may know the properties of each field and where do i write the Dmax
function
thanks again
Revned said:
thank you Steve and Duane Hookom
i really appreciate
:
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
(e-mail address removed)
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