Autonumber

[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

 

[Jim/Chris]

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

Jim

 

[Jim/Chris]

If you want to set the starting number to one of your own go to
http://www.mvps.org/access/tables/tbl0005.htm

Jim

 

[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