AutoNumber - Start at number larger than 1

[Jeff Fredel via AccessMonster.com]

I have a data entry form for project management. Each project has a unique
ID number called PID which i want auto-assigned. But I want to start my
PIDs at 1000 vs. 1 for several reasons. Any idea how to?

Thanks in advance for assistance.

 

[Rick B]

If you do a search, there are ways to do this, but why? An autonumber
should only be used for a unique key. The user should not even see this
number. It should not be used by the end-user in any way.

If the number is to be used, then you should create your own incrementing
number.

Do some searches. Both these issues have been discussed many many times.

 

[Mark Phillipson]

Hi,

If you still wish to use the AutoNumber Data Type, then create an Append
query that Adds 1 record and put 999 into the PID field, then delete the
record. The next record inserted will have a PID of 1000.

Note that if a record is deleted then gaps will exist in the PID sequence.
Also a Compact & Repair will reset the AutoNumber to the next available
value.

--
HTH

Mark Phillipson

Free Add-Ins at; http://mphillipson.users.btopenworld.com/