Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Q: Can you initialise autonumber to start at a specific value?

Status
Not open for further replies.
mikeg8

mikeg8

Technical User
Sep 11, 2003
32
GB
Well, can you? Using autonumber in my table really will make life a whole lot easier for me...but I need to start it at 1001 (its a long story!), then increment by 1 each time for each new record. Is this possible?

Mike

ps Please keep any reply simple...because I am!
 
Sort by date Sort by votes
Hi mikeg8,

Not a recommended practice, but see thread705-608327 for how to do it.

Enjoy,
Tony
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Question
Open filtered for and set cursor at particular record
Replies
1
Views
106
Moss100
Moss100
Moss100
  • Locked
  • Question
Vba code I can call from a query to reformat text
Replies
8
Views
226
Moss100
Moss100
ziffer68
  • Locked
  • Question
Pass Through query to create an alias for DB2 member
Replies
0
Views
247
ziffer68
ziffer68
renigar
  • Locked
  • Question
Code to write file path to field always writes to 1st record 1
Replies
5
Views
244
dhookom
dhookom
Kennelbloke
  • Locked
  • Solved
Refer to Navigation Control Subform Record
Replies
8
Views
398
Kennelbloke
Kennelbloke

Part and Inventory Search

Sponsor

Back
Top