Validating Access [Resolved by Rob]
Hi,
I am helping my sister with one of her college project and try to stay away from VBA. Anyhow just need some information regarding VBA in access. I have put validation in the Datbase Itself using validation rules. Now the validation works fine if I input the data directly into table. If I enter data using Forms then I am presented with a Error message saying You Can not perform this action, instead of the Error Message I set up in the Validation Rule.
I would prefer not to do the validation in the form and keep it into the Database itself. Is that possible in Access? If so how would I get that error msg defined for a particular field?
Also I have managed to setup most of the validation apart from checking for Empty value (NULL) that dont seem to work. How do i set a validation rule so User must enter something for that field.
Cheers for your help.
Danial
Re: Validating Access [Resolved by Rob]
Yes, VBA is a bit strange in some situations.
I have been busy on a VB.NET project lately. I cleared out a quick 50 so there is room again.
:thumb: