Undefined Function

  • Thread starter Thread starter Bald Eagle
  • Start date Start date
B

Bald Eagle

A query which uses the 'Left' function has worked up until last week! Then
it choked and threw up an error message 'Undefined function 'Left' in
expression'. No changes were made to the database since it worked
previously. Could some of the MS security updates which ran automatically
last week have caused a problem? I use Access 2007 and Vista.

What can I do to get this working again?
 
Open any VBA module in your db. Look in Tools\References.
Look for one that is prefaced with "Missing".
Note which one it is. Uncheck it.
Scroll down and recheck it.

Regards

Kevin
 
Bald Eagle said:
A query which uses the 'Left' function has worked up until last week!
Then
it choked and threw up an error message 'Undefined function 'Left' in
expression'. No changes were made to the database since it worked
previously. Could some of the MS security updates which ran automatically
last week have caused a problem? I use Access 2007 and Vista.

What can I do to get this working again?
Click to expand...

Probably a missing or mis-matched reference. Doug Steele has an page
explaining the problem and it's solution at the following URL ...

http://www.accessmvp.com/DJSteele/AccessReferenceErrors.html
 
Thanks to both Kevin & Brendan for the advice. It will be a couple of days
before I get on to the laptop on which the problem appeared - I developed the
database on my desktop (which uses Access 2007 and Windows XP) and it still
works fine here.

Obviously some Vista related update caused the problem on the laptop.
 
Back
Top