"left function " problem???

[fishqqq]

For some reason my home copy of access2003 wont let me use the
following criteria in a query but it seems to work fine at the office.
the error message states: UNDEFINED FUNCTION 'LEFT' IN EXPRESSION.
There must be a setting that needs to be done ??? (i just installed the
home copy and it's the exact version that's on the office computer.

Any help is greatly appreceiated.


expression= 1: Left([company],20)

Tks

 

[Marshall Barton]

For some reason my home copy of access2003 wont let me use the
following criteria in a query but it seems to work fine at the office.
the error message states: UNDEFINED FUNCTION 'LEFT' IN EXPRESSION.
There must be a setting that needs to be done ??? (i just installed the
home copy and it's the exact version that's on the office computer.

That is almost alway caused by a broken reference. In the
VBA window, use Tools - References to remove all unneded
reference libraries. If the problem persists, you will
probably need to install one or more required libraries.

 

[Guest]

Check this out:

http://www.mvps.org/access/bugs/bugs0001.htm

 

[Wolfgang Kais]

Hello "".

For some reason my home copy of access2003 wont let me use the
following criteria in a query but it seems to work fine at the office.
the error message states: UNDEFINED FUNCTION 'LEFT' IN EXPRESSION.
There must be a setting that needs to be done ??? (i just installed the
home copy and it's the exact version that's on the office computer.
expression= 1: Left([company],20)

In the home copy, open a module and click "tools, references" to see
if there are any broken references ("MISSING:"). Delete these and
replace them by existing libraries on that PC.