Library Finder

[Phil_Howes]

Hi

I am trying to find a method of identifying which library a function is associated with.. This is not a specific function but functions in general. For instance. When using code snippets from websites. Posters NEVER include the libraries required. The VBA object browser will not find the library unles the library has aleady been added in which case you dont need to find it.



Can anyone suggest a robust solution to this?? Many people must have come accross this problem.. Has no one got a solution?? Prefferable one that you don't have to throw money at!!!

Regards

[orange]

Can you give a specific example of the problem?

Are you talking about References? http://allenbrowne.com/ser-38.html

[Phil_Howes]

Yes
Those are the references I am taking about.. For example. If I want to use the DAO.querydefs function I have to include the Microsoft DAO 3.6 Object Library in the references.. However, If I find some code that I want to use that uses the dao.querydefs function, unless I have ALREADY added the Microsoft DAO 3.6 Object Library I cannot find which library this function is from.. I wnat to know how to find, from a given function, which library I need to include.

Hope this is making Sense.

[orange]

Don't spend too much time worrying about what is in which library.

These should give you more than you need to be comfortable.

See http://www.accessmvp.com/TWickerath/articles/adodao.htm
http://support.microsoft.com/kb/825796
http://www.accessmvp.com/djsteele/Ac...nceErrors.html

[Phil_Howes]

Thanks , but I have already looked at thes pages..

They cover the general stuff but I am coming accross things like "GetFirstInstallDate" . It is in a Vendor Specific Library "SystemInformationLib" . These sort of functions aren't covered by the general windows/access/office libraries.

Thanks for the info

[orange]

I'm not clear on your issue.
When you create vba, you typically store it in modules in your database. And your documentation will/should identify that.
You may have a Library.mda type file and reference that.
As for third party libraries, they probably come with installation and maintenance instructions. You may have to deal with vendors/suppliers.

[R_Badger]

What I think he means is if he came across a piece of code similar to what is below but without the guide associated to it, how would he know what references he would need:

http://www.jephens.com/2007/05/13/ho...using-outlook/

[Phil_Howes]

R_Badger.. Thats right.. If I came across some code on the internet that said it would perform a task that I needed but didn't include which libraries were needed.. How do you find out which library the Classes , methods and functions are from?

Example:- IOSInfoService.. I want to use this class.. How would you find which library it is in?? ( I know the answer on this occasion but how would you find the answer)>>

Phil

[orange]

I would try google IOSInfoService which results in

http://xpdll.nirsoft.net/ipnathlp_dll.html
http://www.win7dll.info/

But generally the library/reference is with the documentation.
I guess, bottom line, you use the supplier; Google; general forums; or specific forums if it a very special library/area of study.

[Phil_Howes]

I would try google IOSInfoService which results in

http://xpdll.nirsoft.net/ipnathlp_dll.html
http://www.win7dll.info/

But generally the library/reference is with the documentation.
I guess, bottom line, you use the supplier; Google; general forums; or specific forums if it a very special library/area of study.

Thats great thanks.. It is a big help in finding which libraries I need to include.

Phil