query does not work in Access 2003

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

I have a query that uses the "left", "mid", & "right" functions to format a
time field. This query works with all versions of access until 2003 & newer.
The error message is "left is not a valid function" or something like that.
What is the syntax for doing this in 2003 or newer?
 
Those functions are in the VBA library, but its unlikely that's what's
missing. Those errors are common symptoms of one or more missing references,
but provide no indication of which reference it might be.

In the VB Editor: Tools>References and look for a reference marked
"Missing"...
 
I have a query that uses the "left", "mid", & "right" functions to format a
time field. This query works with all versions of access until 2003 & newer.
The error message is "left is not a valid function" or something like that.
What is the syntax for doing this in 2003 or newer?
Click to expand...

As Dave suggests, 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.

John W. Vinson [MVP]
 
Back
Top