ms access training - Autonumbering

Resolved · Low Priority · Version Standard

Tue 17 Jul 2007, 16:46 Delegate Chantil said...

Chantil has attended:
Access Intermediate course
Excel Intermediate course

Autonumbering

How do I set up an alpha-numeric autonumber?

Fri 20 Jul 2007, 09:47 Trainer Richard said...

RE: Autonumbering

Try adding something like

/M#

to the format box on the field properties of the autonumber field.

"M" would stand for the letters that you want to have placed before the autonumber

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

ms access training - Autonumbering

Autonumbering

RE: Autonumbering

Access articles

Access tip:

Splittng a database