If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
invoice number
I would like to add an invoice number to report which is generated only when
the invoice is printed can anyone explain how to do this please |
#2
|
|||
|
|||
invoice number
One solution might be to base InvoiceNo field on an autonum field. Run code
to add the autonum (or some variation of it) to the InvoiceNo field before/when printing the invoice. Bonnie http://www.dataplus-svc.com cjgav wrote: I would like to add an invoice number to report which is generated only when the invoice is printed can anyone explain how to do this please -- Message posted via http://www.accessmonster.com |
#3
|
|||
|
|||
invoice number
Hi
Thanks for your help i;ve done that ut the problem is the number starts at 1 and I would like to tell it were to start "bhicks11 via AccessMonster.com" wrote: One solution might be to base InvoiceNo field on an autonum field. Run code to add the autonum (or some variation of it) to the InvoiceNo field before/when printing the invoice. Bonnie http://www.dataplus-svc.com cjgav wrote: I would like to add an invoice number to report which is generated only when the invoice is printed can anyone explain how to do this please -- Message posted via http://www.accessmonster.com |
#4
|
|||
|
|||
invoice number
On Jun 7, 3:07*pm, cjgav wrote:
Hi Thanks for your help i;ve done that ut the problem is the number starts at 1 and I would like to tell it were to start "bhicks11 via AccessMonster.com" wrote: One solution might be to base InvoiceNo field on an autonum field. *Run code to add the autonum (or some variation of it) to the InvoiceNo field before/when printing the invoice. * Bonnie http://www.dataplus-svc.com cjgav wrote: I would like to add an invoice number to report which is generated only when the invoice is printed can anyone explain how to do this please -- Message posted viahttp://www.accessmonster.com remove the autonumber (make the field type long integer). Add a record. Set the value of invoiceNumber to be one less than the one you want. Change the field type back to autonumber. Compact the database. And there you go. |
#5
|
|||
|
|||
invoice number
Don't think so, Piet.
I don't believe it's possible to change the datatype of a field to Autonumber if the table already has data. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Piet Linden" wrote in message ... On Jun 7, 3:07 pm, cjgav wrote: Hi Thanks for your help i;ve done that ut the problem is the number starts at 1 and I would like to tell it were to start "bhicks11 via AccessMonster.com" wrote: One solution might be to base InvoiceNo field on an autonum field. Run code to add the autonum (or some variation of it) to the InvoiceNo field before/when printing the invoice. Bonnie http://www.dataplus-svc.com cjgav wrote: I would like to add an invoice number to report which is generated only when the invoice is printed can anyone explain how to do this please remove the autonumber (make the field type long integer). Add a record. Set the value of invoiceNumber to be one less than the one you want. Change the field type back to autonumber. Compact the database. And there you go. |
#6
|
|||
|
|||
invoice number
Hi
I've tried that but it seems this is not possible "Piet Linden" wrote: On Jun 7, 3:07 pm, cjgav wrote: Hi Thanks for your help i;ve done that ut the problem is the number starts at 1 and I would like to tell it were to start "bhicks11 via AccessMonster.com" wrote: One solution might be to base InvoiceNo field on an autonum field. Run code to add the autonum (or some variation of it) to the InvoiceNo field before/when printing the invoice. Bonnie http://www.dataplus-svc.com cjgav wrote: I would like to add an invoice number to report which is generated only when the invoice is printed can anyone explain how to do this please -- Message posted viahttp://www.accessmonster.com remove the autonumber (make the field type long integer). Add a record. Set the value of invoiceNumber to be one less than the one you want. Change the field type back to autonumber. Compact the database. And there you go. |
#7
|
|||
|
|||
invoice number
Hi,
as invoice numbers have to follow without holes, never take an autonumber. You'll always run into trouble later. Create a separate table which holds the invoice numbers. Each time you need a new invoice number, you look up the last used, add 1 to it and then update the number in the new table. I always have three fields the last invoice nr. last year, last invoice nr. this year, and last invoice nr. next year. This helps around the end of December, start of January. -- Kind regards Noëlla "cjgav" wrote: I would like to add an invoice number to report which is generated only when the invoice is printed can anyone explain how to do this please |
#8
|
|||
|
|||
invoice number
Hi
Thank you for your help . I'm not sure about this if I 'm not using autonum to generate the numbers how do I do it? "Noëlla Gabriël" wrote: Hi, as invoice numbers have to follow without holes, never take an autonumber. You'll always run into trouble later. Create a separate table which holds the invoice numbers. Each time you need a new invoice number, you look up the last used, add 1 to it and then update the number in the new table. I always have three fields the last invoice nr. last year, last invoice nr. this year, and last invoice nr. next year. This helps around the end of December, start of January. -- Kind regards Noëlla "cjgav" wrote: I would like to add an invoice number to report which is generated only when the invoice is printed can anyone explain how to do this please |
#9
|
|||
|
|||
invoice number
And what happens when you print the same invoice again later? Do you want a
different invoice number to be created? Why don't you create the invoice number when you enter the invoice data in your invoice form? Steve "cjgav" wrote in message ... I would like to add an invoice number to report which is generated only when the invoice is printed can anyone explain how to do this please |
#10
|
|||
|
|||
invoice number
hi
I want to keep the same number . I enter the info in to the database to create a estimate for customer when the estimate is excepted and the job is completed I want a table with invoice date in which I have used an append query to update but I cannot create an invoice number without using autonum which will not produce the numbers I want . "Steve" wrote: And what happens when you print the same invoice again later? Do you want a different invoice number to be created? Why don't you create the invoice number when you enter the invoice data in your invoice form? Steve "cjgav" wrote in message ... I would like to add an invoice number to report which is generated only when the invoice is printed can anyone explain how to do this please |
Thread Tools | |
Display Modes | |
|
|