Left Function not recognized

[lbigk]

Hello,

I am using Access 2003 and I am not sure which library is missing, but when I create a basic select qry and use "Left" function, I get the following error "Undefined function 'Left' in expression. Right and Mid functions work just fine.

Thank you.

 

[Remou]

Look at the references* and see if any are marked MISSING.



===================
* Code Window -> Tools -> References

 

[lbigk]

I have about 15 references added, I checked all the usual suspects: VBA, Object library... Is there a specific one I should check for?

 

[Remou]

No, any reference that is marked MISSING could be the cause of the problem. It will be clearly marked. If this is not the case, try unchecking your references and checking them again.

 

[lbigk]

Thank you, I will give it a try.

 

[maxhugen]

I've also found over the years that in dbs with complex forms &/or reports (with VBA code), Access sometimes fails to compile properly, eg, it doesn't recognise basic things like 'Me' in code.

The 'fix' seems to be to decompile the code, and then recompile it, followed by a Repair/Compact. To decompile, run this from the command line (or a shortcut you set up), like this:

[PathToAccess] [PathTpMDB] /decompile

HTH

Max Hugen
Australia