Access 2007 exception on Date Validation rule

D

Dean Slindee

Here is the Date Validation Rule in the property page for a text box in an
Access 2003 application (.adp): >=DateAdd("d",-30,Date())
This Validation Rule works for users who have Office Access 2003 installed
on their pc's. However, if the user gets Office Access 2007 installed, they
get the following exception:

"The Expression Date you entered in the form control's ValidationRule
property contains the error The function you entered can't be used in this
expression. The (application name) can't parse the ValidationRule
expression you entered. (more text continues)."

I have tested this on my development PC with Office 2007, but cannot
reproduce the problem. This problem has happened in two separate Access
applications, with two different user pc's that have just been upgraded to
Office 2007.

Perhaps there is some Office 2007 option or file not loaded by the Office
2007 install? Anyone got a suggestion?

TIA
Dean Slindee
 

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

Top