Query functionality inconsistent

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

My department uses Access 97 databases that frequently use
Format, Trim, etc functions in queries. For some reason,
a query with one of these functions will work on a user's
machine for a period of time, and then simply stop
working, even though the same query still works on other
machines, AND the same function works in other databases
on the same machine. The error the user receives is below:
------------
Function isn't available in expressions in query
expression: Format(Date(),'m/d/yyyy')
------------

Can anyone shed some light on why this is happening for
me? How would I go about fixing this? A re-install of
Access works, but we shouldn't have to re-install Access
every couple months for each user.

Any help is greatly appreciated.
 
http://support.microsoft.com/default.aspx?
scid=http://support.microsoft.com:80/support/kb/articles/Q1
94/3/74.ASP&NoWebContent=1

-----Original Message-----
My department uses Access 97 databases that frequently use
Format, Trim, etc functions in queries. For some reason,
a query with one of these functions will work on a user's
machine for a period of time, and then simply stop
working, even though the same query still works on other
machines, AND the same function works in other databases
Click to expand...
 
My department uses Access 97 databases that frequently use
Format, Trim, etc functions in queries. For some reason,
a query with one of these functions will work on a user's
machine for a period of time, and then simply stop
working, even though the same query still works on other
machines, AND the same function works in other databases
on the same machine. The error the user receives is below:
Click to expand...

This appears to be the very common References bug. Open any
module in design view, or open the VBA editor by typing
Ctrl-G. Select Tools... References from the menu. One of the
..DLL files required by Access will probably be marked
MISSING. Uncheck it, recheck it, close and open Access.

If none are MISSING, check any reference; close and open
Access; then uncheck it again. This will force Access to
relink the libraries.
 
Back
Top