Can autonumber be forced to start at a number other than 1, lets say 1001. Beginner 3 Field Properties 5 (00:00)-(00:37)
Reply from Richard Rost:
Yes, but it involves a trick. Just insert as many BLANK RECORDS as you want (in your case, 1000) and then add your first real record. It will have ID 1001. Now you can go back and delete the first 1000 blank records.
Yes, you can do this automatically with a macro, SQL, or some VBA programming, but that's beyond the scope of my beginner lessons.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 3.