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
|
|||
|
|||
How to change the starting value of AutoNumber field?
Dear all,
I've searched and read the Access Help file about this question but I still don't understand how to solve it. For example, in my database, I have a table named tblFileInfo and it have a AutoNumber field named FileNo (also set as Primary key to link with other tables). And the "New Values" Property of this field is set to "Increment". Now, my database is blank, how should I amend in the property of this field so that the starting value is not from 1? (say, if I want to start the value from 10000,10001,10002.....) Thanks a lot!!!!! Gary -- Message posted via http://www.accessmonster.com |
#2
|
|||
|
|||
How to change the starting value of AutoNumber field?
Use an Append query to write the value one less than you want to the table.
Details of how: Set AutoNumbers to start from ... at: http://allenbrowne.com/ser-26.html -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "hkgary33 via AccessMonster.com" u23950@uwe wrote in message news:64c340360c93a@uwe... Dear all, I've searched and read the Access Help file about this question but I still don't understand how to solve it. For example, in my database, I have a table named tblFileInfo and it have a AutoNumber field named FileNo (also set as Primary key to link with other tables). And the "New Values" Property of this field is set to "Increment". Now, my database is blank, how should I amend in the property of this field so that the starting value is not from 1? (say, if I want to start the value from 10000,10001,10002.....) |
Thread Tools | |
Display Modes | |
|
|