Available References in Access 2007

Z

Zia Texas

I am looking for a description of the various Microsoft References available
under the Available References dialog box that is accessed under Tools |
References from the Microsoft Visual Basic screen.

Does anyone know of a list that describes the references?
 
A

Albert D. Kallal

Zia Texas said:
I am looking for a description of the various Microsoft References
available
under the Available References dialog box that is accessed under Tools |
References from the Microsoft Visual Basic screen.

Does anyone know of a list that describes the references?

There's no such a list that exists, because every single new piece of
software you install on your computer will likely appear in that list. In
other words you're asking for a list that it finds every piece of software
that you've ever purchased and installed on your computer. Such a list is a
fantasy and does not exist.

Worse is that many of the items in that reference list are in fact huge
products that can take years to learn. For example if you install outlook,
then you'll see outlook in your tools->references. (and I seen huge shelf's
of books on just learning Outlook).

So, unfortunately that lists has to be documented on a case by case basis.
if
you install the Adobe reader object, then you'll likely see an ActiveX
control in the tools reference. You have to go to the Adobe site and read up
on the big pile of documentation for that object. The same goes if to you
so
decide to install excel on your computer, then excel will appear in that
tools->reference list.

So, this list is going to be different on every computer, and it going to be
based on whatever software you've installed on your particular computer, and
my computer will be different then yours.

I can learn how to do some math, but I'm not going to find a reference on
the Internet that lists out every single number and single math problem on
the Internet. This is the same situation for those references.

If you're asking what are the basic references you need for typical access
application to run, then I suggest that you create a brand new blank access
database and then go into the code editor and look at the tools->references
you get. This approach usually gives you the basic reference list that
access needs run correclty.
 
R

Rick Brandt

I am looking for a description of the various Microsoft References
available under the Available References dialog box that is accessed
under Tools | References from the Microsoft Visual Basic screen.

Does anyone know of a list that describes the references?

On every version of Access the list shows all registered COM libraries on
your computer thus the list is not dependent on what version of Access
you are using.

Note that the majority of listed references wouldn't work in Access if
you tried them and many more are not licensed for your use in Access.

The best advice is to not use any reference other than the defaults as it
is difficult to do so if you want to share the file with others. If you
need functionality in an external COM library use late binding which does
not require a reference.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top