"WindAndWaves" <ac****@ngaru.com> wrote in message
news:Jt********************@news.xtra.co.nz...
Hi Gurus
I have recently discovered references in the VB section of MS Access,
however, when choosing references, I noticed that there are more than who
knows how many options. How and/or where do you i get more information on
all the references available? Are there any that I should be using / should
be avoiding (I know about the DAO stuff)?
Keen to hear any suggestions.
In my opinion you should avoid ALL of them.
I should qualify that. Open a new blank file and look at the three or four
references that are set by default. Those are all you should ever need. If you
build functionality that is dependent on other references you will have nothing
but grief if you try to use those files on PCs besides the development box.
On the rare occasion that you need to automate an outside library use late
binding which doesn't require a hard reference and you will have a much easier
time when distributing to multiple target machines.
Also don't be confused into thinking that what you are seeing is a "list of
references provided by Access that you can add to your Access app". It is
actually a list of registered libraries on your Windows OS. There is no
implication that you should (or even can) use all of them in your Access app.
The same applies to the "additional tools" toolbar that is available in form and
report design. That is a list of all registered ActiveX controls on your
system, but only a small minority of them are compatible with Access.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com