undefined function

[rzkl]

Hello,
I have a problem with a database. It was created in Access 2000 on my work PC. I emailed it to my home PC, I can open it no problem but when I go to run one of the queries that uses the function "Left" in it I get a popup saying Undefined function 'Left' in Expression. Any Ideas???

Thanks in advance
Rob

 

[MStef]

Hello rzkl!
Open any VBA code (form or module).
Click ont "Tools", then on "References",
look at "Available References:", if you
find any "MISSING" references, deselect it.
(MStef alias Štef)

 

[rzkl]

That worked thank you

 

[24sharon]

Missing

check
Strings.Left

I think it will help.