O'Reilly logo

Access™ 2007 VBA Programmer's Reference by Armen Stein, Geoffrey Griffith, Rob Cooper, Teresa Hennig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

G.12. The References Collection and Reference Object

In addition to the various Access objects detailed in this appendix, you can use objects from other applications such as Excel, Word, Outlook, and non-Microsoft programs such as AutoCad and Peachtree Accounting to program in Access. To use these other object models, set a reference to their type libraries. The References collection contains a reference for every external type library you add to the References dialog box within your code.

The properties of the Reference object are described in the following table.

PropertyData TypeDescription
BuiltInBooleanSpecifies whether a reference points to a default Reference necessary for Access to function properly.
CollectionReferences objectReturns a reference to the collection that contains an object.
FullPathStringSpecifies the path and filename of the referenced type library.
GuidStringReturns a GUID that identifies the type library in the Registry.
IsBrokenBooleanSpecifies whether a Reference object points to a valid reference in the Registry.
KindVbext_RefKind EnumSpecifies the type of reference that a Reference object represents.
MajorLongSpecifies the major version number of an application you're referencing.
MinorLongSpecifies the minor version of the application you're referencing.
NameStringThe name of the Reference object.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required