Access 2007 exception on Date Validation rule

[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

 

[Linq Adams via AccessMonster.com]

When apps run fine on one machine and not on another or run fine in one
version and not when run under a newer version, the first thing you have to
think about are missing references.

Here are Doug Steele's detailed instructions on how to troubleshoot the
problem:

http://www.accessmvp.com/DJSteele/AccessReferenceErrors.html