Autonumber

  • Thread starter Thread starter Andrea
  • Start date Start date
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
 
copy the table
delete all the records in original table
compact the database
append the records from the copied table

Jim
 
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
 
Back
Top