Undefined Function Error

[JBOUTIN]

I'm stumped. Anyone have clue?

All my reports that contain Access string functions like =Left([Lastname],1) are no longer identifed by Access. They worked at one time, but I have done so much coding I don't know when they stopped working.

I tried to create a new report with the same function, but get the same "Undefined Function" error.

I also created another database with the same function to see if Access was corrupt, but it worked fine.

Any thoughts?

Thanks

 

[R. Hicks]

This is usually caused by a "Missing" library reference.

Open any module in design view, select Tools/References in the VBA Window if Access 2000/2002 or Tools/References in Access Main Menu if Access 97. Check the list of library references for "Missing" attached to a checked reference. If you locate one and the reference is not needed in the app, simply uncheck the offending reference and your problem should be cleared up. If the missing reference is needed in the application then you will need to install and properly register the needed files associated with the library on the offending machine.
If this problem is in Access 2000/2002 and you are using DAO references in your code, you may need to enable (place a check in box) Microsoft DAO 3.6 library. This can cause the problem you describe also.

HTH
RDH

[This message has been edited by R. Hicks (edited 12-03-2001).]