AutoNumber Question 3

[Minuet]

I have an AutoNumber field in one of my forms. I added a number of records to the form, which I later deleted because I wanted to start over. When I tried making a new record after deleting all previous records, the AutoNumber started at 5 instead of back at 1. Is there any way I can reset the AutoNumber field?

 

[chrissie1]

delete the autonumber field save the table and put in a new one with the same name this should begin from 1

"What a wonderfull world" - Louis armstrong

 

[Minuet]

I tried deleting the AutoNumber field, but it won't let me because it's part of a relationship. Is there any other option?

 

[chrissie1]

just undo the relationship. redo the autonumber and remake the relationship

its the best way and the fastest "What a wonderfull world" - Louis armstrong

 

[Minuet]

It worked! Thanks so much for the advice!

 

[chrissie1]

dont forget the star "What a wonderfull world" - Louis armstrong

 

[WildHare]

Actually, if all the records in the parent table have been deleted, a simple COMPACT of the database would have reset the autonumber back to 1.

Jim Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[chrissie1]

didnt know that one either "What a wonderfull world" - Louis armstrong