468,785 Members | 1,691 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,785 developers. It's quick & easy.

How to I make my Autonumber field always begin with 1?

I have figured out that there is no easy way to create an autonumber field in a query, but that there is a way (supposedly) to create an autonumber field in a table or rather, there is already an autonumber field (the ID field). Is there any way I can make this ID or autonumber field to always begin with 1 so that it acts as a sort of counter/sequential numbering field for the records I put into the table?

I am appending the records from a query of fields from another table in case that has anything to do with it.
Feb 25 '11 #1

✓ answered by TheSmileyCoder

Yes, I would normally do it in VBA. Im sure it could be done in SQL aswell, if one is more familiar with SQL.

4 2451
TheSmileyCoder
2,321 Expert Mod 2GB
Autonumber fields reset to 1 when compacting (If table is empty)

Another option is to use code to delete the table, and then recreate it (using code)
Feb 25 '11 #2
To delete the table and recreate it using code would I do that in VBA?
Feb 25 '11 #3
TheSmileyCoder
2,321 Expert Mod 2GB
Yes, I would normally do it in VBA. Im sure it could be done in SQL aswell, if one is more familiar with SQL.
Feb 25 '11 #4
I figured it out, thanks! ................
Feb 25 '11 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Jan Hendrickx | last post: by
3 posts views Thread by ben.werdmuller | last post: by
1 post views Thread by S. van Beek | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
2 posts views Thread by Marin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.