ValidationRule bug?

  • Thread starter Vladimír Cvajniga
  • Start date
V

Vladimír Cvajniga

Question #1:
Due to internal rules I'm not allowed to set ValidationRule on database
level. On form level how do I tell Access not to leave a record if some
fields don't meet validation criteria? ValidationRule doesn't work as
expected and in some cases it is possible to leave a record even if
validation criteria don't match!!!

Question #2:
Is there any function in A2002 to check validation rules field by field,
record by record (on form's RecordsetClone level)? We had that function in
my beloved PC FAND...

TIA

Vlado
 
R

Rick Brandt

Vladimír Cvajniga said:
Question #1:
Due to internal rules I'm not allowed to set ValidationRule on
database level. On form level how do I tell Access not to leave a
record if some fields don't meet validation criteria? ValidationRule
doesn't work as expected and in some cases it is possible to leave a
record even if validation criteria don't match!!!

Question #2:
Is there any function in A2002 to check validation rules field by
field, record by record (on form's RecordsetClone level)? We had that
function in my beloved PC FAND...

TIA

Vlado
Click to expand...

Do all such testing in the BeforeUpdate event of the form and set the Cancel
argument of that event to True when anything fails your tests.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ValidationRule bug? 4
Access 2007 exception on Date Validation rule 1
Validation Rule problem 6
A2002: Recalc bug? 0
BeforeUpdate or ValidationRule property... preventing saving data in field 0
Set validation rule for many fields with vba? 7
Debugging... GoToControl, SetValue, ValidationRule error? 4
Run-time error 2115 when changing a dtpicker's value in a tab cont 1

Top