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

autonumber

ResolvedVersion 2003

Andrew has attended:
Access Introduction course

Autonumber

Is it possible to create an autonumber with a specific format? For example currently our reference numbers are in the following format

MI1234 is it possible to set this autonumber up?

Also, for a different number we use the date of the enquiry followed by A B or C for the 1st, 2nd or 3rd query of that day so the second query on 15th June 2010 would be listed

100615B is it possible to set this up?

RE: Autonumber

Hi Andrew

Thanks for your post which we have reviewed. We are reasonably confident a solution can be found for this however to reach it will be beyond the scope of this forum.

We will need to see your working files and then be able to get back to you with a scope of work, hours required and related trainer costs to complete.

If you would like to progress this please reply to my email.

Kind regards

Jacob

Tue 29 Jun 2010: Automatically marked as resolved.

Access tip:

Compact database automoatically

To ensure optimal performance, you should compact and repair your

Open the Access database or Access project that you want Access to compact automatically.
On the Tools menu, click Options.
Click the General tab.
Select the Compact on Close check box.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.