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

  • Thread starter Sherri at Quality Envelope
  • Start date
S

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.
 
A

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"
 

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

Autonumber field in Excel that behaves the same as Access 0
Finding the right style field in VBA 0
How do I set focus (and select text) on a text box on a modeless userform? 0
Problem with SET & REF function 0
change the starting vaule for an autonumber field access 2007 5
Page numbering with Merged Document and IF statements 1
How do I change the starting value of autonumber (Access 2007)? 2
Part Autonumber 2

Top