Autonumber

[configger]

You have probably been asked this a thousand times or more, but is there anyway to get the autonumber to start at a different number than 0 or 1, I have tried this, it kind of done this to a 'point' but left all the other entries stuck at that number, which isn't exactly ideal

 

[jdraw]

http://office.microsoft.com/en-us/access/HP051887741033.aspx

 

[configger]

http://office.microsoft.com/en-us/access/HP051887741033.aspx

I can't get to the 'Required Field'

 

[Brianwarnock]

Perhaps you don't need to, have you followed the instructions?
Is it a new table?

Brian

 

[configger]

Perhaps you don't need to, have you followed the instructions?
Is it a new table?

Brian

Ah right yes, I see, thanks

 

[gemma-the-husky]

but - although you can manage an autonumber, you shouldnt need to or want to.

If you think you need to, then you should be adding an appropriate sequential control field to your master table, and managing the numeric sequence of that.

You cannot guarantee an intact numerical sequence with an autonumber field