Left String Function

[Guest]

In an Access 2000 query, the left string function works properly on some
machines, but on others this error message appears:
Undefined function 'Left' in expression.
How might I resolve this?

 

[Guest]

Hi,

This is most of the time caused by missing references in VBA so make sure
all necesarry components are installed on the machine which causes this error.

 

[Allen Browne]

The machines where this fails have a reference problem.

Open any code window, and choose References on the Tools menu.
Locate the one(s) that are checked and have the word 'MISSING'.

More info on references:
http://allenbrowne.com/ser-38.html