Help with Autonumber

[Gary Scott]

Hi,

I work in a small organisation and we have had a small database designed for
us by a NOW defuncted company. Within the database we use a screen for
invoicing on this screen it uses the "autonumber" facility however, the
system crashed many months ago and a IT cons. worked on it to get it working
however, he has now left the country (what is it with us and IT professionals
leaving). Because of this our numbering system has gone to pot. We wish to
restart the autonumbering system on a new number (we use a 5 digit number
XXXXX, and we want to begin the renumbering at 130000 is there a way i can
go into design view of the invoicing screen and change the numbers to begin a
new renumbering scheme.?????

Thanks for any help provided

 

[Allen Browne]

See:
Set AutoNumbers to start from ...
at:
http://members.iinet.net.au/~allenbrowne/ser-26.html

The article explains how to execute an Append query that adds a record 1
less than the value you want to start from.

Alternatively, you can use ADOX to set the Seed property of the
autoincrement column directly.

 

[Roger Carlson]

Frankly, if you care what the value is, you are using the autonumber
incorrectly. The ONLY thing an autonumber field should be used for is to
create a unique primary key value for a record that will relate to records
in another table. If you are using the value in any sort of real-world
sense, you should create the number programmatically yourself. There are
various ways to do this. The simplest is to use the DMax function as
illustrated in a small sample database called "AutonumberProblem.mdb" that
you can find on my website (www.rogersaccesslibrary.com).

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L