How do I change the starting number in an AutoNumber field?

[Sherri at Quality Envelope]

I have done this before for establishing in-house docket numbers, and it's
worked out perfectly. There is a help topic that steps you through the
process, but I cannot find it, and would like to use this procedure again.

 

[Allen Browne]

Here's some code that sets the Seed of the AutoNumber:
http://allenbrowne.com/func-ADOX.html#SetSeed

In older versions (Access 97 and earlier), you had to execute an append
query that assigned a number 1 less than you need to the field, and then
delete that record. Details:
Set AutoNumbers to start from ...
at:
http://allenbrowne.com/ser-26.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

"Sherri at Quality Envelope"