Invoice Numbers

[blanch2010]

First let my apologies. I posted a question earlier but I can't find we're I
posted it!

I would like to know if there's a way to auto number an invoice before it's
printed?

I would think a new table would be required but I'm really not sure how to
setup what's required.

Thank you in advance.
Don

 

[Gina Whipp]

Don,

It depends on how far in the past you want to generate the Invoice number
before it is printed AND the steps you go thru to print the Invoice but I
can give you a yes, it can be done. However, more information required to
tell how?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

First let my apologies. I posted a question earlier but I can't find we're
I
posted it!

I would like to know if there's a way to auto number an invoice before it's
printed?

I would think a new table would be required but I'm really not sure how to
setup what's required.

Thank you in advance.
Don

 

[blanch2010]

Hi Gina, thank you for the response.

I have a form that I pull up the client name in and pass it off to a report
(invoice) which opens in print preview.

The form uses a query as does the report.

There has been no invoices printed yet so I guess, to answer the question, I
don't think I need past invoice numbers generated.

I'm not sure if this is the info your looking for?

Thanks again for the response.

Don

 

[Gina Whipp]

Don,

Okay, so when exactly do you want the Invoice number generated? As it goes
inot Print Preview?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi Gina, thank you for the response.

I have a form that I pull up the client name in and pass it off to a report
(invoice) which opens in print preview.

The form uses a query as does the report.

There has been no invoices printed yet so I guess, to answer the question, I
don't think I need past invoice numbers generated.

I'm not sure if this is the info your looking for?

Thanks again for the response.

Don

 

[Gina Whipp]

Don,

Does you table for Invoices have a field? Also can you copy paste the code
you use to generate the Invoice here. If you do not have a table that
stores Invoice number and Date and the like then please describe how you
generate and Invoice.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Yes, that would be perfect.

Will the invoice number be stored into a table?

Don,

Okay, so when exactly do you want the Invoice number generated? As it goes
inot Print Preview?

Hi Gina, thank you for the response.

I have a form that I pull up the client name in and pass it off to a report
(invoice) which opens in print preview.

The form uses a query as does the report.

There has been no invoices printed yet so I guess, to answer the question,
I
don't think I need past invoice numbers generated.

I'm not sure if this is the info your looking for?

Thanks again for the response.

Don

Don,

[quoted text clipped - 19 lines]

.

 

[Gina Whipp]

Don,

WHat I was going to suggest was...

YourInvoiceFieldNameOnYourForm = DMax("InvoiceIDField","YourInvoiceTable") +
1

....placed on the button BUT you are now saying your look-up form is
generating a number. So now I am a little confused. If you are already
generating the number then you can pass that Invoive number to the subforms.
So perhaps I don't need to see any button code. Though I still don't have a
clear picture of how you are generating the Invoice number, sounds like...

1. Open Main Form
2. Press button open subform that generates number
3. Type generated Invoice number into Main Form and subforms

....is that what is happening?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Yes I do have an Invoice table.

I think I got it.

I am using a sub form with the client lookup form that will allow for an
invoice number, date & the client id. The lookup form is generating a
number
that I type into the invoice number field on the sub form. Now I will try
and make the invoice number & date field auto generate the correct
information into the sub form.

The report (invoice) is using a query and has three sub reports inside of
its
body.

Do you want to see that query?

Or the code behind the button I click to send the report it's information?

I think the way I'm going at it with the sub form will work. I need to test
further.

Thanks again Gina

Don

Don,

Does you table for Invoices have a field? Also can you copy paste the code
you use to generate the Invoice here. If you do not have a table that
stores Invoice number and Date and the like then please describe how you
generate and Invoice.

Yes, that would be perfect.

Will the invoice number be stored into a table?

Don,

[quoted text clipped - 23 lines]

 

[Steve]

Don,

The report is not the time to generate the inventory number. The inventory
number needs to be generated in the form where you record the invoice. From
there it will be saved in your invoice table. The invoice report is only for
printing out what is in the invoice table! See my first response.

Steve
(e-mail address removed)

Yes, I would like the number generated as the report goes to print
preview.

I have a number being generated in the form now, but that number is not
transferring into the report.

I also have a new situation: When I select a record in the form to pass
to
the report, the record is not being recorded into the tblInvNum. All
that's
going into this table is the generated number.

I'm using the form as a record source only, it does no updating to any
records.

Sounds like I need to start over with the form then worry about the report
later.

Are you understanding what I'm trying to do?

Thanks Gina

Don

Don,

Okay, so when exactly do you want the Invoice number generated? As it
goes
inot Print Preview?

Hi Gina, thank you for the response.

I have a form that I pull up the client name in and pass it off to a
report
(invoice) which opens in print preview.

The form uses a query as does the report.

There has been no invoices printed yet so I guess, to answer the question,
I
don't think I need past invoice numbers generated.

I'm not sure if this is the info your looking for?

Thanks again for the response.

Don

Don,

[quoted text clipped - 19 lines]

.

 

[Steve]

From my first post:

<<InvoiceNumber = DMax("[InvoiceNumber]","TblInvoiceNumber") + 1>>

You took four responses to get there!!!

Steve

Don,

WHat I was going to suggest was...

YourInvoiceFieldNameOnYourForm = DMax("InvoiceIDField","YourInvoiceTable")
+
1

...placed on the button BUT you are now saying your look-up form is
generating a number. So now I am a little confused. If you are already
generating the number then you can pass that Invoive number to the
subforms.
So perhaps I don't need to see any button code. Though I still don't have
a
clear picture of how you are generating the Invoice number, sounds like...

1. Open Main Form
2. Press button open subform that generates number
3. Type generated Invoice number into Main Form and subforms

...is that what is happening?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Yes I do have an Invoice table.

I think I got it.

I am using a sub form with the client lookup form that will allow for an
invoice number, date & the client id. The lookup form is generating a
number
that I type into the invoice number field on the sub form. Now I will try
and make the invoice number & date field auto generate the correct
information into the sub form.

The report (invoice) is using a query and has three sub reports inside of
its
body.

Do you want to see that query?

Or the code behind the button I click to send the report it's information?

I think the way I'm going at it with the sub form will work. I need to
test
further.

Thanks again Gina

Don

Don,

Does you table for Invoices have a field? Also can you copy paste the
code
you use to generate the Invoice here. If you do not have a table that
stores Invoice number and Date and the like then please describe how you
generate and Invoice.

Yes, that would be perfect.

Will the invoice number be stored into a table?

Don,

[quoted text clipped - 23 lines]

.

 

[Gina Whipp]

Steve,

If you read my post you will notice that I have ruled DMax out as it appears
he is already generating Invoice numbers. I only showed it as what I
*thought* might be an option. And yes, I'll take as many questions response
as I need to make sure I am not just throwing a solution out there that may
or may not work. Assuming is a terrible thing.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

From my first post:

<<InvoiceNumber = DMax("[InvoiceNumber]","TblInvoiceNumber") + 1>>

You took four responses to get there!!!

Steve

Don,

WHat I was going to suggest was...

YourInvoiceFieldNameOnYourForm = DMax("InvoiceIDField","YourInvoiceTable")
+
1

...placed on the button BUT you are now saying your look-up form is
generating a number. So now I am a little confused. If you are already
generating the number then you can pass that Invoive number to the
subforms.
So perhaps I don't need to see any button code. Though I still don't have
a
clear picture of how you are generating the Invoice number, sounds like...

1. Open Main Form
2. Press button open subform that generates number
3. Type generated Invoice number into Main Form and subforms

...is that what is happening?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Yes I do have an Invoice table.

I think I got it.

I am using a sub form with the client lookup form that will allow for an
invoice number, date & the client id. The lookup form is generating a
number
that I type into the invoice number field on the sub form. Now I will try
and make the invoice number & date field auto generate the correct
information into the sub form.

The report (invoice) is using a query and has three sub reports inside of
its
body.

Do you want to see that query?

Or the code behind the button I click to send the report it's information?

I think the way I'm going at it with the sub form will work. I need to
test
further.

Thanks again Gina

Don

Don,

Does you table for Invoices have a field? Also can you copy paste the
code
you use to generate the Invoice here. If you do not have a table that
stores Invoice number and Date and the like then please describe how you
generate and Invoice.

Yes, that would be perfect.

Will the invoice number be stored into a table?

Don,

[quoted text clipped - 23 lines]

.

 

[Gina Whipp]

Steve,

If you had read his response you will notice he is generating prior in a
form. He then copies it to another form which is why I altered my answer to
say perhaps just passing the value would work.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Don,

The report is not the time to generate the inventory number. The inventory
number needs to be generated in the form where you record the invoice. From
there it will be saved in your invoice table. The invoice report is only for
printing out what is in the invoice table! See my first response.

Steve
(e-mail address removed)

Yes, I would like the number generated as the report goes to print
preview.

I have a number being generated in the form now, but that number is not
transferring into the report.

I also have a new situation: When I select a record in the form to pass
to
the report, the record is not being recorded into the tblInvNum. All
that's
going into this table is the generated number.

I'm using the form as a record source only, it does no updating to any
records.

Sounds like I need to start over with the form then worry about the report
later.

Are you understanding what I'm trying to do?

Thanks Gina

Don

Don,

Okay, so when exactly do you want the Invoice number generated? As it
goes
inot Print Preview?

Hi Gina, thank you for the response.

I have a form that I pull up the client name in and pass it off to a
report
(invoice) which opens in print preview.

The form uses a query as does the report.

There has been no invoices printed yet so I guess, to answer the question,
I
don't think I need past invoice numbers generated.

I'm not sure if this is the info your looking for?

Thanks again for the response.

Don

Don,

[quoted text clipped - 19 lines]

.

 

[Steve]

Don,

First you need an Invoice table with an InvoiceNumber field as I showed in
my first post. Then you need to include InvoiceNumber in the recordsource of
your form and have an InvoiceNumber textbox on your form. Select that
textbox, open Properties and go to the Data tab. Put the following in the
Default property:
DMax("[InvoiceNumber]","TblInvoiceNumber") + 1
When you create a new record by entering something in any field on your
form, InvoiceNumber will automayically calculate when you save the record.
And that will put the value of InvoiceNumber in your invoice table.

Regarding the report.......
InvoiceNumber is a simple field in your Invoice table so to get it on the
report you just need to be sure InvoiceNumber is in the recordsopurce of the
report and that there is a textbox on the report to display the
InvoiceNumber.

Steve
(e-mail address removed)

Gina & Steve

The DMax thing worked fine.

I can generate a number just by opening the form.

What I can't do is take that generated number and:

a: have that number put itself into a table. Which I'm able to do by
adding
a subform linked to the table, and entering in the generated number
manually.

b: The number being generated is not being copied into the report. i am
currently working on that situation.

Thank you both for the help. I will be asking more questions I'm sure.

I continue to learn more everyday thanks to you guys.

Thanks again.

Don

Steve,

If you read my post you will notice that I have ruled DMax out as it
appears
he is already generating Invoice numbers. I only showed it as what I
*thought* might be an option. And yes, I'll take as many questions
response
as I need to make sure I am not just throwing a solution out there that
may
or may not work. Assuming is a terrible thing.

From my first post:

<<InvoiceNumber = DMax("[InvoiceNumber]","TblInvoiceNumber") + 1>>

You took four responses to get there!!!

Steve

Don,

[quoted text clipped - 36 lines]

.