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

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

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

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

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

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

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

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

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

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