Donate SIGN UP

Access - Data validation query

Avatar Image
sidavies | 15:42 Fri 10th Feb 2006 | Technology
2 Answers

I have created a table and made a form which is to be used to popoulate the table but I would like to run a query which checks that certain fields have been input.


so: the form is completed, the user clicks exit and the validation runs and informs the users of the 'blank' fields



many thanks

Gravatar

Answers

1 to 2 of 2rss feed

Best Answer

No best answer has yet been selected by sidavies. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Perhaps a better solution would be to set 'Required' to be true in the table design. Then Access would not allow records to be created with empty fields, if this is what you you are trying to achieve.
Question Author

Thanks for your response Perrin.... but do you know how I can insert an error message also? So it says "please go back and complete...."



1 to 2 of 2rss feed

Do you know the answer?

Access - Data validation query

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.