 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2007Undefined function 'Date' in expression
I have a form (MS Access 2003 frontend) that had worked well before and then now when I open that form, suddently there is an error message pop up, "Undefined function 'date' in expression". I have another database with similar designing that works just fine! Can you please tell me why is it? I recently convert the backend to SQL Server 2005. Maybe it's corrupted? Thank you in advance for your help - tim More likely, it is a missing reference problem in VBA. Look at the references in the working database and see if there is one missing in the non working database. I don't remember which library the Date function is in, but this is the usual cause of this problem.  SignatureDave Hargis, Microsoft Access MVP > I have a form (MS Access 2003 frontend) that had worked well before and then > now when I open that form, suddently there is an error message pop up, [quoted text clipped - 3 lines] > Server 2005. Maybe it's corrupted? > Thank you in advance for your help - tim Dave, Thank you for your comment. Missing reference is the first thing I thought. I did check the reference in VBA, but I can not find the **Missing** listing. tim > More likely, it is a missing reference problem in VBA. Look at the > references in the working database and see if there is one missing in the non [quoted text clipped - 8 lines] > > Server 2005. Maybe it's corrupted? > > Thank you in advance for your help - tim It can still be a missing reference problem. the **missing** means the reference has been identified, but the file of the reference can't be found. It the reference has not been established or has been lost or accidentily removed, you will not see the **missing** SignatureDave Hargis, Microsoft Access MVP > Dave, > Thank you for your comment. Missing reference is the first thing I thought. [quoted text clipped - 13 lines] > > > Server 2005. Maybe it's corrupted? > > > Thank you in advance for your help - tim If none of the references show up as "MISSING:", what can help is adding an additional reference at random, backing out of the dialog then going back in and unselecting the reference you just added. If that still doesn't work, try to unselect as many of the selected references as you can (Access may not let you unselect them all), back out of the dialog, then go back in and reselect the references you just unselected. (NOTE: write down what the references are before you delete them, because they'll be in a different order when you go back in) SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) > It can still be a missing reference problem. the **missing** means the > reference has been identified, but the file of the reference can't be [quoted text clipped - 27 lines] >> > > Server 2005. Maybe it's corrupted? >> > > Thank you in advance for your help - tim |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.