"Undefined function 'Date' in Expression"

  • Thread starter Thread starter eric
  • Start date Start date
E

eric

Hi,

I am working on a network, on one computer I can use the
Date() function in access. on the other computers I
get: "Undefined function 'Date' in Expression"

What can I do to ensure that this command is recognized?

Thanks in advance,

Eric
 
You have a problem with the VB library references in the database on the
failing computer. On that computer, open any module and choose References
from the Tools menu. Uncheck any marked Missing - this is what's causing
all function calls from queries to or VB to fail. You should have the VB
library, Access library, and either DAO or ADO library. Any others are
probably superfluous unless your application uses ActiveX controls or needs
to reference the Office, Word, or Excel libraries.

This usually happens in a database that you've converted from a prior
version. Is this the case?

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
 
This is what is 'checked' at the moment in references.

Visual Basic for Applications
Microsoft Access 9.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.1 Library
Microsoft Calendar Control 9.0
MISSING: shappmgr 1.0 Type Library
Microsoft Forms 2.0 Object Library

Should I uncheck the 'MISSING: shappmgr 1.0 Type Library'?

I'm not sure if this database was coverted from a prior
version but I will find out.

Thanks!


Eric
 
You can uncheck the missing library and then choose Compile from the Debug
menu to see if that breaks anything. If not, you're all set. You probably
do not need OLE Automation or Microsoft Forms 2.0 Object Library either.
And yes, it looks like this was converted from a previous version.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
 
Thanks!!

Eric
-----Original Message-----
You can uncheck the missing library and then choose Compile from the Debug
menu to see if that breaks anything. If not, you're all set. You probably
do not need OLE Automation or Microsoft Forms 2.0 Object Library either.
And yes, it looks like this was converted from a previous version.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)



.
Click to expand...
 
Back
Top