E.19. The References Collection and Reference Object

When programming in Access you can use not only the various Access objects detailed in this appendix, but also objects from other applications, such as Excel, Word, Outlook, or non-Microsoft programs like AutoCad and Peachtree Accounting. In order to use these other object models, you need to 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.

E.19.1. Reference Object Properties

The properties of the Reference object are listed 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 file name 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 (vbext_rk_Project, vbext_rk_TypeLib)Specifies 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

Get Access 2003 VBA Programmer's Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.