Auto Number

[Olan Gotcher]

I have imported a old data base into Access 2003 and have a auto-number
field that was being used in the old file. It is a membership number and
needs to increment by one for each new member. I need to give it a starting
number (for instance 8650) and have it go on from there but I have not been
able to get it to do that. It always wants to start at 1 and continue from
that point. I know there must be a way to do this but as of now I have not
figured it out. I am just entering the numbers manually at this point but
would really like to have Access put that number in automatically.

Thanks
Olan Gotcher

 

[Fred Boer]

Dear Olan:

It sounds like you want a custom autonumber field. There is a helpful sample
database here that presents a solution:

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

HTH
Fred Boer

 

[Douglas J. Steele]

Olan: I answered this for you a few days ago, when you asked in
microsoft.public.access.devtoolkits. Was there something you didn't
understand about that answer? If so, you never posted any follow-up
questions to that newsgroup (which would have been appropriate than starting
a new thread in another newsgroup...)

 

[Olan Gotcher]

For some reason I never saw it come up on the message group. I am not sure
what was going on but in my newsgroup messages it never went past 9/22/06 so
I never saw my message or any reply. I tried another message group to see
if that would work and it seems to have helped but it is still very slow in
getting updates for me to read. I am sorry if you answered it in the other
group, but I never got the answer. I will try to find your answer in the
other group.

Olan Gotcher

 

[Douglas J. Steele]

What I posted then:

"If you can live with gaps in the numbering, and assuming you've got the
existing members in a table already, create a second table that's identical
to the existing one, but make the MembershipID an Autonumber field. Create
an Append query that takes the data from the existing table and appends it
to the new query. The next member you add to the new table will be one more
than the last number in the table.

"If you can't live with gaps in the numbering, don't use an Autonumber
field.
Rather, you'll have to "roll your own", by doing a DMax call to the table to
determine the current highest number, then adding one to it."

 

[Olan Gotcher]

Thank you very much for the help. I will give this a shot and see if I can
use your idea.

Olan Gotcher