98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Form validation
Form validation
Resolved · Low Priority · Version 2003
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?
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.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Splittng a databaseSplit your database into two (at least). |
