Auto numbering

  • Thread starter Thread starter Laurena
  • Start date Start date
L

Laurena

Auto numbering starts at 1 but I want it to start at
11890. How do I change the auto numbering format????
 
in Access help see topic "Change the starting value of an incrementing
AutoNumber field"

regards,
CTaHk0
 
The simplest approach is to import a record containing the value 11889.
Details:
Set AutoNumbers to start from ...
at:
http://allenbrowne.com/ser-26.html

In Access 2000 and later, it is also possible to set the Seed of the
Autonumber field. Use the ADOX library to set the "Seed" property of the
Column in the Table in the Catalog.
 
You have been directed to the tricks, but keep in mind that auto numbers
are not consecutive numbers, it is designed to provide unique numbers.
Expecting it to keep number consecutive is likely to prove a disappointment.
There are other ways to do consecutive numbers that work.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Access problem 0
Auto fill not working 2
The next Grand Theft Auto title has been officially announced 0
Simple Ref number for a form 2
Auto Number ID Field 4
changing start value in the auto number 4
Can I reset an auto number in an access table 21
auto number in query 1

Back
Top