AutoNumber

[Guest]

I've created a simple database utilizing an ID Number field as my primary
key. I would like to start the autonumbering with 1, 2, 3... etc. How can I
do this? Go easy on me...I'm a rookie. Thank you in advance.

 

[Fred Boer]

Dear Skydiver:

Are you using Autonumber as the field type for this ID number field? If so,
and if you are concerned with the values held in this field, then you
shouldn't use Autonumber. An autonumber field has one purpose - to provide a
unique row identification number. It isn't intended to be used to provide a
perfectly sequential number. It will develop gaps.

If you need a sequential number field, then you need to create a "custom
Autonumber". There is a demo showing how to do this here:

http://www.rogersaccesslibrary.com/download3.asp?SampleName=AutonumberProblem.mdb

You will, of course, need to do all your data entry and editing work using
forms and *not* directly in tables.

You might want to look here:

http://www.mvps.org/access/tencommandments.htm (Your issue is #7...)...

HTH
Fred Boer

 

[Jeff Boyce]

Why?

As in "why do you care what value the autonumber has"?

Access Autonumbers are intended for use as unique row identifiers. They are
not guaranteed to be sequential (they can 'skip'; they can be set to
random). Autonumbers are generally unfit for human consumption.

That said, if you'll describe WHY you want the numbers to be "1, 2, 3..."
the newsgroup readers may be able to offer alternative approaches.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Search for
"Change the starting value of an AutoNumber field" in Access Help.