Functions not working in Access 2000 2

[cbarrol]

Hello,

I am running access 2000 SR1 on an XP machine. Some of the Access functions wont work in a query, such as:
Hired: Format([Date Hired],"mm/dd/yyyy")
When I run the query, I get an error stating:
Undefind function "Format" in Expression
I get this error regardless if I manually key the expression or if I use the expression builder.

In asking around someone else thought this was due to an issue between Access 2000 & XP, because the same query works fine on an Access 2003 / XP combo. Unfortunately, the machine I need to run the application on has to be Access 2000 due to other constraints.

Any ideas or experience with this issue?

Thanks,
Craig

 

[PHV]

Does the db compiles properly ?
Double check the references.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SgtJarrow]

Have you checked for MISSING references?? Open any code window, Tools | References and look for any that are preceeded with MISSING:.

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB.NET Programmer

 

[cbarrol]

Thanks for the quick response.
The only missing reference is
SNAPSHOT VIEWER CONTROL

 

[PHV]

So, download it:

http://activex.microsoft.com/activex/controls/access/snapview.asp

Or uncheck the reference and compiles the db to be sure you really need it.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[cbarrol]

Downloaded & Installed but still get the
Undefind function "Format" in Expression
error when I try to run the query.

I get the same error with LEFT, MID, RIGHT functions

 

[PHV]

Uncheck the reference, close the dialog, reopen it and check the reference.
Compiles the db.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[cbarrol]

Wow. This worked. (At least I got past the error message) Never would have thought SNAPSHOT VIEWER CONTROL would have anything to do with functions not working...I will know for sure next week when I get some test data..

Thanks a bunch PH, here is a star.
This is the best forum on the net.