Form validation

Resolved · Low Priority · Version 2003

Tue 23 Mar 2010, 15:18 Delegate 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?

Thu 25 Mar 2010, 16:44 Trainer 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.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

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