Autonumber

A

Andrea

please can someone help and in basic terms tell me how i
can reset the autonumber, i have tried the help and
cannot see where i am going wrong. All i want is to
create invoices with an existing number ie: 23604. but it
keeps just giving me 1 when i have done the temp table
and query??? confused HELP
 
J

Jim/Chris

copy the table
delete all the records in original table
compact the database
append the records from the copied table

Jim
 
P

Pieter Wijnen

Invoice numbers are not good candidates for AutoNumber, as you most likely
want them to be in a unbroken sequence
Better to set up a seperate connection (transaction) to a table, retrieve &
update just in time (when you *know* you're going to use the number - ie
*absolutely* sure - if there's such a thing)

HTH

Pieter Wijnen

When all else fail try:
http://www.mvps.org/access
http://www.granite.ab.ca
 
Top