If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access 2007 exception on Date Validation rule
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 |
#2
|
|||
|
|||
Access 2007 exception on Date Validation rule
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/Ac...nceErrors.html -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200908/1 |
Thread Tools | |
Display Modes | |
|
|