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
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