Starting an AUTONUMBER at a specific number

K

kfowlow

Group,
I have a database that I want to give colleagues to input data when they
travel. It is a copy of my larger database but without the data. They will
have blank tables and they can fill in their data and when they get back they
can give it to me to update the main database. To keep things straight and
less work for me. I want to start off each colleague on a different
AUTONUMBER. They will have numbers like 9000,10000, 11000, 12000. How can I
start the AUTONUMBER at a specific number? Maybe I can't. Is there a way to
paste in a specific number in a record?

Thanks for the help and Happy Holidays.
 
F

Fred Boer

Hello:

Autonumbers can be manipulated, IIRC, but an autonumber shouldn't be used in
a situation where the value of the number matters. An autonumber is designed
to create a unique identifier for a record, and it isn't guaranteed to
remain in sequence. So if the value of the number matters, as it does here,
don't use an Autonumber - create your own counter field. Roger Carlson has a
useful sample here:

http://www.rogersaccesslibrary.com/...?TID=395&SID=4b1a1cf12zcc94c95437117efaz7e98d

HTH
 
M

MikeR

kfowlow said:
Group,
I have a database that I want to give colleagues to input data when they
travel. It is a copy of my larger database but without the data. They will
have blank tables and they can fill in their data and when they get back they
can give it to me to update the main database. To keep things straight and
less work for me. I want to start off each colleague on a different
AUTONUMBER. They will have numbers like 9000,10000, 11000, 12000. How can I
start the AUTONUMBER at a specific number? Maybe I can't. Is there a way to
paste in a specific number in a record?

Thanks for the help and Happy Holidays.
http://www.databasedev.co.uk/reset_autonumber.html
Mike
 

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

Top