Re: Generate my own autonumber?
- From: "BruceM" <bamoob@xxxxxxxxxxxxxxxxxx>
- Date: Mon, 6 Feb 2006 07:37:09 -0500
I have used a technique based on an example that can be found here:
http://www.rogersaccesslibrary.com/download3.asp?SampleName=AutonumberProblem.mdb
I don't know if there is an advantage to using the code in the link John
provided. I am offering this link simply as a suggestion that has worked
for me. Note that if you don't need for the user to see the number when the
record is being created, holding off running the code until the form's
Before Update event will minimize the likelihood of an error because of a
duplicate value. From another angle, running the code after the first field
is completed (or after the first character is typed in a new record) will
similarly minimize the chance of an error event. Roger's example includes a
provision for when two users are entering a record at the same time, but the
fewer error events you need to run the better, I would think.
"Alec M1BNK" <AlecM1BNK@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D47E0894-7B35-420C-AFA7-3FCB17553354@xxxxxxxxxxxxxxxx
How is the question. i need to create an auto incrementing number for each
successive record, but one which will maintain the sequence infallibly
with
no gaps.
Before anyone asks, here's the why. Our accounts manager is unhappy becase
the autoinvoicing system I have implemented inside an access database,
uses
the autonumber record ID from the table of invoice data to generate an
invoice reference number. As we all know, any database using autonumber
aquires gaps, missing numbers from the sequence, more users = more
mistakes =
more gaps. Apparently the auditors might think there is something fishy
going
on if the invoice numbers are not in perfect sequence.
Alec
.
- Prev by Date: RE: YES OR NO TO DATABASE?
- Next by Date: Re: Departmental Database Design
- Previous by thread: Re: Generate my own autonumber?
- Next by thread: Re: i am looking for multy room sound distribution template
- Index(es):
Relevant Pages
|
