referencing DAO360.dll

[smig]

DAO360.DLL (Access 2003) is causing me some problems

If I move the db to another machine (Also Access 2003) sometimes I get an error 3085 - Undefined function FORMAT in expression

I found that if I unrefernce the DAO360.DLL and refernce to it again problem solved
Probably because of different localization.

I know how to refernce a file using code.
How can I reference this file, or more exact how can I know where it is located? Or should I deploy the one I use on the development machine?

 

[thechazm]

Re: rereferncing DAO360.dll

I would directly depoly the one that you use with the machines because you would spend way to much time trying to located and find the information on the files you are trying to work with. Just have it in the same directory as the access project and you should be ok. At least I think. Good luck

 

[apr pillai]

Re: rereferncing DAO360.dll

Check the following link for info and guidance:

Ms-Access and Reference Library

 

[vbaInet]

Re: rereferncing DAO360.dll

DAO360.DLL (Access 2003) is causing me some problems

If I move the db to another machine (Also Access 2003) sometimes I get an error 3085 - Undefined function FORMAT in expression

I found that if I unrefernce the DAO360.DLL and refernce to it again problem solved
Probably because of different localization.

I know how to refernce a file using code.
How can I reference this file, or more exact how can I know where it is located? Or should I deploy the one I use on the development machine?

The versions change. Reference it in your Access 2003 db, develop in your 2007 environmnent, deploy to 2003.

 

[ChrisO]

Re: rereferncing DAO360.dll

You should be able to drop the reference altogether and late bind it by using CurrentDb.

Chris.

 

[smig]

Re: rereferncing DAO360.dll

The versions change. Reference it in your Access 2003 db, develop in your 2007 environmnent, deploy to 2003.

I'm developing in access 2003

What really make me wonder is what DAO has to do with the format function, isn't it a VBA function?

You should be able to drop the reference altogether and late bind it by using CurrentDb.

Chris.

Can I late bind DAO and VBA?

 

[ChrisO]

Re: rereferncing DAO360.dll

No, you can't late bind DAO and VBA.

You can late bind DAO but you can't late bind VBA because it's the top reference which can't be removed.

Chris.