Library References 101

[annsolomon]

I seem to keep tripping over my feet when it comes to library references. Can someone point me to a good primer?

I need answers to very basic questions like:

How do you know which reference(s) you need in your db?
How do you create your own library?
Is there a way to troubleshoot references? (For example, I just found out that some code I borrowed didn't work in my db because I referenced both ADO and DAO. I guess that's a no no because as soon as I removed the reference to ADO the code worked fine.) Ann

 

[annsolomon]

After posting this I spent some time trying to get familiar with the Object Browser. (I suppose that would be an obvious place to start but, without formal VBA training, my learning experience has been somewhat hit and miss.) I can see where the Object Browser will be a big help to me once I get the hang of it.

When I reference DAO this code works:
Set rsHistory = CurrentDb.OpenRecordset("tblEmployeeAddressHistory", Dynaset)

Using the Object Browser I tried to find comparable code to use if I referenced ADO instead of DAO. It seemed to me that I should change OpenRecordset to Open but I got this compile error with the word Open highlighted: Method or data member not found.

Geez. I sure wish the light bulb would come on. Ann