"left function " problem???

F

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
 
M

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.
Click to expand...


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.
 
W

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)
Click to expand...

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.
 
Top