Creating random unique numbers in access

Resolved · High Priority · Version 2010

Mon 2 Dec 2013, 16:34 Delegate Enzo said...

Enzo has attended:
Visio Introduction course
Excel Advanced course

Creating random unique numbers in access

How can I auto create unuique and random reference number for records so that they are all different.

Sat 7 Dec 2013, 22:42 Trainer Doug said...

RE: Creating random unique numbers in access

Hi Enzo

As we saw on the training you can use an Autonumber field (named ID for example) and change the New Values property from Increment to Random. This produces a 10 figure random number.

As half of these numbers will be negative you can create a separate calculated field instead with the Abs function. This will make all the numbers positive.

Abs([ID])

To create a shorter number you could use

Abs(Left([ID],5))

This will create a random 5 figure number.

Doug Dunn
Best STL

Mon 9 Dec 2013, 13:15 Trainer Doug said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Mon 16 Dec 2013: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Create a custom Close button on a Form

By default, Forms that you create in Access have a full set of control buttons, that is, a title bar with Minimize, Maximize and Close buttons in the top right-hand corner and a Control Menu in the top left-hand corner.

Sometimes Access needs to follow certain procedures or events as users close a Form (such as automatically opening another Form perhaps). So it is often a good habit to create a custom Close button on a Form for everyone to use, rather than the standard closing cross.

To create a custom Close button:

1) In Form Design View, draw a Command Button onto the Form.

2) Use the Command Button Wizard to select Form Operations under Categories, and Close Form under Actions.

3) Choose Finish.

Access then creates the button and code to close the form for you. You can add any extra code that needs to run as the Form closes to the same Close procedure.

However, the creation of a custom Close button is pointless if the closing X in the top right-hand corner of the Form remains active. To make the closing X inactive, open the Form Properties box then on the Format tab set the Close Button setting to No. This will grey out the closing X leaving it visible, but inactive.