Re: Increment Number Format
From: Roger Carlson (NO-Rog3erc-SPAM_at_hotmail.com)
Date: 05/10/04
- Next message: DazedConfused: "How to Increment Number Format"
- Previous message: Roger Carlson: "Re: Increment Number Format"
- In reply to: DazedConfused: "Increment Number Format"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 10 May 2004 14:04:01 -0400
You can't use an Autonumber to accomplish this. You cannot format or
control an autonumber in any way. Rather, you will have to create your own
incrementing function.
Take a look at the following downloadable samples:
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Increment%20Alpha%20Field.mdb'
http://www.rogersaccesslibrary.com/download3.asp?SampleName=AutonumberProblem.mdb
-- --Roger Carlson www.rogersaccesslibrary.com Reply to: Roger dot Carlson at Spectrum-Health dot Org "DazedConfused" <dw.nospam@nospamyahoo.com> wrote in message news:CVNnc.57242$sK3.46935@nwrddc03.gnilink.net... > I know this must have been answered before but I am new to Access 2000. > > I have a incrementing AutoNumber field set up for an Invoice Numbering > System. > How or what formatting code would/could I use to accomplish this? > I would like to format the number like this and increment it by 1 each time > I create an Invoice. > > Field Name: InvoiceID > > example: WSI-0001, WSI-0002, etc > > Thanks in Advance > >
- Next message: DazedConfused: "How to Increment Number Format"
- Previous message: Roger Carlson: "Re: Increment Number Format"
- In reply to: DazedConfused: "Increment Number Format"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
