Auto numbering

L

Laurena

Auto numbering starts at 1 but I want it to start at
11890. How do I change the auto numbering format????
 
C

cTaHk0

in Access help see topic "Change the starting value of an incrementing
AutoNumber field"

regards,
CTaHk0
 
A

Allen Browne

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.
 

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

Hyperlinking automatic?? 1
Text duplication question 0
Automatic indexing in footnotes - solved 0
Auto populate value from one task to another in MS PROJECT 0
Word Document Auto Update 0
Paragraph numbering in Word 1
Modern equivalent of Autotext in Word? 0
Auto-Numbering in a Table in MS Word 1

Top