98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Autonumber fileds
Autonumber fileds
Resolved · Medium Priority · Version 2003
Mon 27 Apr 2009, 17:07Delegate Patrick said...
Patrick has attended:
Access Introduction course
Access Intermediate course
Autonumber fileds
I have cereated a database and each record has been assigned an autonumber.
However, a few recirds have been deleted and the autonumbering now starts at 20. How can I re-number the autonumbers so that they start at 1 again?
Regards,
Patrick
Tue 28 Apr 2009, 09:01Trainer Rajeev said...
RE: Autonumber fileds
Dear Patrick
Thank you for attending Access Courses!! I hope you enjoyed the courses and benefited from them.
Please refer to the following link to reset your Auto number lists.
You will be required to create a make table query. It has got step by step instruction so it should be quite straight forward to follow it.
http://support.microsoft.com/kb/812718
I hope this has answered your query.
If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT
Tue 5 May 2009: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Combo box for finding recordsYou can use a combo box in a form to look up a record. If you place the comb box in the Form header, by then selcting they a field type from the drop down loist, you will see the record for it |
