If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Primary Key start number
Hi
How can you set a primary key number (autonumber) to start from a particular number - eg "10000" I have invoices issued from an old accounts package - and am creating a new database to replace it, but do not want to duplicate old invoice numbers. I seem to remember in the past a way of setting this but cant remember - any help please ? Thanks |
#2
|
|||
|
|||
Mat
Using an autonumber as a value which humans will see is risky -- they (autonumbers, not humans) are designed for use as a unique row identifier, to help in relating tables. If you have a number (invoice number?) you wish humans to see and understand, consider creating your own "custom autonumber" (check this newsgroup, mvps.org, or Google.com for examples). If you must carry on, despite these dire warnings, create an append query that appends a single value to the autonumber field. If you want to start after "10000", append that number. Then open the table and delete that row. The next autonumber SHOULD be 10001 (but don't say I didn't warn you!). Good luck! Jeff Boyce Access MVP "Mat" wrote in message ... Hi How can you set a primary key number (autonumber) to start from a particular number - eg "10000" I have invoices issued from an old accounts package - and am creating a new database to replace it, but do not want to duplicate old invoice numbers. I seem to remember in the past a way of setting this but cant remember - any help please ? Thanks |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I reset the primary key which is a automatic number in a t | Gary | General Discussion | 2 | November 18th, 2004 02:17 AM |
Setting A Number Equal to Another Number | slag018 | General Discussion | 1 | October 19th, 2004 04:16 AM |
Field in Table | LMB | New Users | 14 | October 11th, 2004 07:13 AM |
Restart Autonumber | Traci | New Users | 22 | July 21st, 2004 01:10 AM |
Access 2000 help with Mid and InStr | Box 666 | New Users | 6 | June 11th, 2004 06:26 PM |