Error 3705 Function Not Found

[scotthutchings]

I have a database created on a windows xp computer in Access 2007. When I install a runtime version on several computers with windows 7 I started getting and error code #3075 Function Isn't Available when I try to pull up a report that uses formatting functions like currency, date, left() etc. I believe it has to do with the references on the machine that I used to develop the database being more updated than the references on the target machines. Does this sound right? If so, how can I update the target computers or downgrade the references on the developper machine?

 

[Pat Hartman]

The development machine needs to have reference files at or lower than the level the users will have. The alternative is to change your code to late binding. This means instead of defining an Excel.Object you would define an Object and Access would figure out what you were talking about at runtime. The big downside to this is that you loose all intellisense for the reference libraries. That means that you also can't use enumerated values. You will have to hard code the reference numbers