Ideas on how to start

  • Thread starter Thread starter Revned
  • Start date Start date
R

Revned

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
 
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...
 
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.
 
thank you Steve and Duane Hookom

i really appreciate

Steve said:
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)



Revned said:
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
Click to expand...
Click to expand...
 
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

Steve said:
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)



Revned said:
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
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top