A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

invoice number



 
 
Thread Tools Display Modes
  #1  
Old June 7th, 2009, 01:31 PM posted to microsoft.public.access.tablesdbdesign
cjgav
external usenet poster
 
Posts: 54
Default 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  
Old June 7th, 2009, 02:28 PM posted to microsoft.public.access.tablesdbdesign
bhicks11 via AccessMonster.com
external usenet poster
 
Posts: 529
Default 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  
Old June 7th, 2009, 09:07 PM posted to microsoft.public.access.tablesdbdesign
cjgav
external usenet poster
 
Posts: 54
Default 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  
Old June 7th, 2009, 09:53 PM posted to microsoft.public.access.tablesdbdesign
Piet Linden[_2_]
external usenet poster
 
Posts: 280
Default 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  
Old June 7th, 2009, 10:13 PM posted to microsoft.public.access.tablesdbdesign
Douglas J. Steele[_3_]
external usenet poster
 
Posts: 3,143
Default 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  
Old June 7th, 2009, 10:39 PM posted to microsoft.public.access.tablesdbdesign
cjgav
external usenet poster
 
Posts: 54
Default 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  
Old June 8th, 2009, 08:49 AM posted to microsoft.public.access.tablesdbdesign
Noëlla Gabriël
external usenet poster
 
Posts: 79
Default 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  
Old June 8th, 2009, 02:45 PM posted to microsoft.public.access.tablesdbdesign
cjgav
external usenet poster
 
Posts: 54
Default 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  
Old June 8th, 2009, 03:19 PM posted to microsoft.public.access.tablesdbdesign
Steve[_72_]
external usenet poster
 
Posts: 190
Default 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  
Old June 8th, 2009, 03:39 PM posted to microsoft.public.access.tablesdbdesign
cjgav
external usenet poster
 
Posts: 54
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:32 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.