autonumber
The UK's Number 1 for Microsoft Office Training
Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » AutoNumber

Recommend training98.1 %
recommend us
More live stats...

The UK's most regular
instructor-led training courses.

Training information:

See also:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

See also:
Hints and tips
Forum topics

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

AutoNumber

resolvedResolved · Low Priority · Version 2007

replyReply Mon 19 Jul 2010, 10:55Delegate Lucia said...

Lucia has attended:
Access Intermediate course

AutoNumber

Hi!

I wanted to know if I can get the ID field to go back to 1 after deleting 200 records, or at least show a number decreased of 200 in the forms.

Thanks!
Lucia

For upcoming training course dates see: Pricing & availability

replyReply Tue 20 Jul 2010, 15:03Trainer Newson said...

RE: AutoNumber

Hi Lucia

Please find a link below from Microsoft which explains how you can reset the autonumber field. I'm assuming this is a primary key. The link discusses steps for 2003 and 2007 and what to do if the primary key spans multiple tables.

YOU SHOULD BACK UP YOUR DATABASE BEFORE ATTEMPTING ANY STEPS IN THE ARTICLE BELOW


http://support.microsoft.com/kb/812718

Many thanks

Newson

 

Access articles

· Want to Become the Office Hero? MS Project Training Could be the Answer
· How To Use Lookups For Data Entry In Microsoft Access
· How Does The Startup Work When Access 2010 Launches The Northwind Database
· Save Time And Effort In Access By Creating Relationships
· Microsoft Access Training Unleashes the Power of the Pivot Table

Please browse our web site to find out more about
advanced micorosoft access training and other Microsoft training courses.

Access tip:

Changing MS Programs Text Size

A handy way to increase or decrease the size of text in Microsoft Word, Microsoft PowerPoint, Microsoft FrontPage, or Microsoft Publisher, first, select the text you want to resize.

Then, to increase the font size, press CTRL+SHIFT+>.

To decrease the font size, press CTRL+SHIFT+<.

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. infomst
All prices offered for business users and exclude VAT. E&OE · Terms & conditions · Privacy policy