Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

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

AutoNumber

ResolvedVersion 2003

Wed 18 Aug 2010, 15:11 Delegate Alison said...

Alison has attended:
Access Introduction course

AutoNumber

How can I get autonumbers to be more than one digit long at the start eg 00001 not just 1?

Wed 18 Aug 2010, 17:49 Trainer Anthony said...

RE: AutoNumber

Hi Alison, thanks for your query. Select the autonumber field in design view and go down to the "Field Properties" panel. In the General tab click into Format and simply put "00000". Save the table and switch back to Datasheet view. Your first autonumber should now read "00001" and so on.

Hope this helps,

Anthony

Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

AutoNumber

AutoNumber

RE: AutoNumber

Access articles

Access tip:

Splittng a database