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
|
|||
|
|||
Undefined 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 |
#2
|
|||
|
|||
Undefined function 'Date' in expression
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. -- Dave Hargis, Microsoft Access MVP "Tim" wrote: 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 |
#3
|
|||
|
|||
Undefined function 'Date' in expression
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 "Klatuu" wrote: 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. -- Dave Hargis, Microsoft Access MVP "Tim" wrote: 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 |
#4
|
|||
|
|||
Undefined function 'Date' in expression
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** -- Dave Hargis, Microsoft Access MVP "Tim" wrote: 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 "Klatuu" wrote: 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. -- Dave Hargis, Microsoft Access MVP "Tim" wrote: 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 |
#5
|
|||
|
|||
Undefined function 'Date' in expression
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) -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Klatuu" wrote in message ... 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** -- Dave Hargis, Microsoft Access MVP "Tim" wrote: 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 "Klatuu" wrote: 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. -- Dave Hargis, Microsoft Access MVP "Tim" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|