starting autonumber on 1000 instead of 0
- Thread starter rdeanh
- Start date
Hi Rocky H,
I have never found a way to do this automatically, but have had the need for it also. Hopefully, someone will respond with a better way to do this, but if not, this is what I did:
I went into Excel and made a column of numbers from 1 to 999. I did this in Excel just because it's easy and quick with the fill handle. Then, I imported the Excel file into a new Access table and let it add a primary key. I then deleted all the records (which were blank anyway). Therefore, the next record that was added started at 1000.
As far as having 5 records already, you could use an append query to append them to your new table. So those will be the first 5 records with 1000-1005.
Like I said, hopefully someone will respond with a better way to do this. Unfortunately, I don't know of one. But, at least this accomplishes the same thing!
Let me know if you need more info.
Krysti
I have never found a way to do this automatically, but have had the need for it also. Hopefully, someone will respond with a better way to do this, but if not, this is what I did:
I went into Excel and made a column of numbers from 1 to 999. I did this in Excel just because it's easy and quick with the fill handle. Then, I imported the Excel file into a new Access table and let it add a primary key. I then deleted all the records (which were blank anyway). Therefore, the next record that was added started at 1000.
As far as having 5 records already, you could use an append query to append them to your new table. So those will be the first 5 records with 1000-1005.
Like I said, hopefully someone will respond with a better way to do this. Unfortunately, I don't know of one. But, at least this accomplishes the same thing!
Let me know if you need more info.
Krysti
jfgambit
Kinetic Card Dealer
- Local time
- Today, 13:29
- Joined
- Jul 18, 2002
- Messages
- 798
You could set the Format of the Field in the Table to be /1000, but the problem with that is that once you get to record 1999 the next number would be 11000. If you set the Format to be 0000 in the table then the numbers will start with 0001, but they will roll to 2000 after 1999, so you might still have to import 999 "false" records before starting with 1000...
