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
|
|||
|
|||
Autonumbering fields
Can anyone advise whether it is possible to reset the start number on an
Autonumber field? I am writting a billing database and it is to follow on from a previous system so I would like to start from a specific number and not 1. Thanks Jean |
#2
|
|||
|
|||
See:
Set AtuoNumbers to start from... at: http://members.iinet.net.au/~allenbrowne/ser-26.html The article explains how to temporarily append a record 1 less than the number you want, which sets it up for you. In Access 2000 and later, you can also set the Seed property of the auto-increment Column using ADOX. -- 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. "Jean" wrote in message ... Can anyone advise whether it is possible to reset the start number on an Autonumber field? I am writting a billing database and it is to follow on from a previous system so I would like to start from a specific number and not 1. |
#3
|
|||
|
|||
Thanks Allen, I am not ready to run this now but it prepares me for the
final database. Jean "Allen Browne" wrote in message ... See: Set AtuoNumbers to start from... at: http://members.iinet.net.au/~allenbrowne/ser-26.html The article explains how to temporarily append a record 1 less than the number you want, which sets it up for you. In Access 2000 and later, you can also set the Seed property of the auto-increment Column using ADOX. -- 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. "Jean" wrote in message ... Can anyone advise whether it is possible to reset the start number on an Autonumber field? I am writting a billing database and it is to follow on from a previous system so I would like to start from a specific number and not 1. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Automatic filling of fields in table two from table one | Jim Kelly | Database Design | 1 | September 27th, 2004 10:16 PM |
How do I import data to user-defined fields? | Bill at Ithaca HS | Contacts | 2 | September 17th, 2004 05:31 PM |
Custumized Filter doesn't work in some fields | Jaime DomÃnguez | Contacts | 1 | September 16th, 2004 01:14 AM |
Excluding Fields in Reports | Fakhruddin Zavery | General Discussion | 2 | September 8th, 2004 07:32 PM |
Mail Merge two fields that have multiple lines with new line control code | Eric Li | Mailmerge | 7 | May 25th, 2004 06:10 PM |