I have a table set up that I import an Excel file to. This table has an autonumber field to keep the sequence of the rows set. Before I do an import, I delete all of the records form the import table. However, the autonumber field starts with the last number used and it is getting to be a pretty large number.

Is there a way, either in the table properties or via VBA code, to reste the autonumber to 1 or some other number.

Thank you for your help.

You should find this link helpful.

__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07
If your issue is resolved...follow this link for directions on how to use the Solved thread tool!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"

I tried the code that you provided, but it didn't seem to reset the autonumber. And as I looked at the code, it appears to only work if I want to set the counter higher. (If the highest number is 500, I can make the next one 1000). But it doesn't let me reset it back to 100 or 1.

Am I missing something?

With all of the records deleted, if you Compact and Repair the AutoNumber seed is set back to 1.

__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07
If your issue is resolved...follow this link for directions on how to use the Solved thread tool!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"