Ideas on how to start

[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

 

[Duane Hookom]

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.

 

[Revned]

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]

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)

 

[Duane Hookom]

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.

 

[Revned]

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

 

[Revned]

one more thing steve

may know the properties of each field and where do i write the Dmax function

thanks again

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

 

[Steve]

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

one more thing steve

may know the properties of each field and where do i write the Dmax
function

thanks again

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

 

[Revned]

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

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

one more thing steve

may know the properties of each field and where do i write the Dmax
function

thanks again

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

 

[Steve]

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

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

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

one more thing steve

may know the properties of each field and where do i write the Dmax
function

thanks again

:

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