Error Message 'Error evlauation CHECK constraint. 'in validation r

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Every time a switch my form to form view and test the fields by putting the
information in and then try to return to design view I get this error message
"Error evaluation CHECK constraint. 'in validation rule." Does anybody know
what this means?

James E.
 
Hi,


Your form involved a form that has a CHECK constraint. There is no
UserInterface that allows you to see those constraints. If the constraint is
not otherwise documented, it can be found, with some detective work, in the
system tables. You need to spot its name. When you have the name of the
constraint, you can

CurrentProject.Connection.Execute "ALTER TABLE tableNameHere DROP CONSTRAINT
constraintNameHere"


in the immediate debug Window.



Hoping it may help,
Vanderghast, Access MVP
 
Thank you, this is very helpful!

James Eggert

Michel Walsh said:
Hi,


Your form involved a form that has a CHECK constraint. There is no
UserInterface that allows you to see those constraints. If the constraint is
not otherwise documented, it can be found, with some detective work, in the
system tables. You need to spot its name. When you have the name of the
constraint, you can

CurrentProject.Connection.Execute "ALTER TABLE tableNameHere DROP CONSTRAINT
constraintNameHere"


in the immediate debug Window.



Hoping it may help,
Vanderghast, Access MVP
Click to expand...
 
Back
Top