ACCESS DATABASE

  gaily 10:54 03 Jun 2005
Locked

I have set up a database and form saving an old database and form. It has worked but the automatic numbering for each of the forms will not zero. Any ideas, as I can't understand the help responses.

  Access genu 11:59 03 Jun 2005

The only wat to reset an auto number in access is to compact and repair

  sat481 14:36 03 Jun 2005

There is another way... It's called an Append Query.. Its a bit complicted but this explains it fairly well..

click here

If you have questions about it then ask again and I'll do my best. I have used it a few times for work databases and it does work.

Good luck

Sat

  sat481 14:39 03 Jun 2005

Sorry it missed a bit out... Set it to the maxium value.. and run the Append Query.. then set it to the minium value and run it again.. the finally set it to one before the figure you want and run it a final time. The next record you enter will be the required start number. You can delete the records that were created.

Sat

  gaily 16:01 03 Jun 2005

THANK YOU EVERYONE - THE COMPACT AND REPAIR WORKED A TREAT AND WAS REAL EASY. JUST ANNOYED I HADN'T THOUGHT OF IT.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?