Undefined Function

[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?

 

[Alex Dybenko]

Hi,
open any module and look under menu Tools-references, should not be missing
references there

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[kc-mass]

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

 

[Brendan Reynolds]

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?

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

 

[Bald Eagle]

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.