Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Form validation

	98.1 % recommend us
	More live stats...

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

Training information:

Form validation

Resolved · Low Priority · Version 2003

Reply Tue 23 Mar 2010, 15:18Delegate Daiga said...

Daiga has attended:
Access Intermediate course

Form validation

One of the fields on my form are combined from two field dat (filed year YYYY and field called code - 0000). This new field contains both values and is automatically generated when both fields are filled by inputer. I need to make sure this new combined field is unique and there will be no duplicates. Let's say only one code per year. How to set up the validation rule? Is it possible in expression builder?

For upcoming training course dates see: Pricing & availability

Reply Thu 25 Mar 2010, 16:44Trainer Anthony said...

RE: form validation

Hi Daiga, thanks for your query. That is certainly possible, although the process is rather long to post on this forum. However, try this weblink. It details the procedure you need:

http://www.ehow.com/how_13623_prevent-duplicate-values.html

Hope this helps,

Anthony

Thu 1 Apr 2010: Automatically marked as resolved.

Access articles

· Interested In The Golden Rules For Building Access Databases?
· Enhancing The Customer Experience With Access
· How Access Can Provide The Key To Successful Stock Management
· Getting To The Nitty-gritty Via Microsoft Access
· How To Sort And Filter A Table In Access 2010

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

Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips