Left String Function

Richard Burda · Jul 19, 2005

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?

JaRa · Jul 19, 2005

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 · Jul 19, 2005

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

Left String Function

Richard Burda

JaRa

Allen Browne