Function not Available in 2007

[Rob Bunocore]

I have an Access 2002 mdb that I'm trying to use on a machine with
2007. Although the mdb opens and runs, I've encountered a few small
errors when opening various queries.

The error message is something about "The onclick event didn't result
in the name of a function or macro...." and "the function
Left([Encounter_ID],6) is your query is not available..."

All these functions work fine in the other versions. Any ideas?

Robby

 

[Allen Browne]

Did you add your database folder to the trusted locations in A2007? The code
probably won't run at all if you don't. You do that through:
Office Button | Access Options | Trust Center | Trust Center Settings

If you open the code window, and choose References on the Tools menu, are
any libraries marked "MISSING"? If so, see:
Solving Problems with Library References
at:
http://allenbrowne.com/ser-38.html