Access 2007 Contacts Templates

[SparX]

I have created a database for personal info, with about 10,000 entires to
add, and about 8000 more to go. I am currently around 1600 personal entries
and I have noticed that several of the GENERATED numbers are skipped. When
you create a new entry, you can hit the "new," button and it will bring a box
for all of the fields, .. Name , address, phone numbers, email... ect. And
when you do this it GENERATES a number. And it is literally as simple, as .
First entry is #1, and second entry is number #2. ... and so on. Well it
skipped several numbers and it will not show number 35. It goes from 34 to
36. I need to create that number 35, along with other missing entriy numbers.

I have tried exporting it, making changes, and re-importing it, but when
I do that so much of the info is no longer availble, like the new button is
no longer there... ect. SO how do I generate a custom ID Numbers in Access
2007, or create a skipped ID number. Let me know... thanks,

 

[Bill Mosca]

One way to fudge the AutoNumber is to run an insert (append) query and
specify the number.

INSERT INTO MyTable(ID, FirstName, LastName)
VALUES(35,'Bill', 'Mosca')

But I don't advise this as it might mess up the index on the AutoNumber. And
there really is no sound reason for not skipping a number unless it is for
an audit trail. The user should never see that field anyway. It is
meaningless to him.