Access.2007.VBA.Bibl..

(John Hannent) #1
FIGURE 14.24
The Query and Field Names report.

List Table Fields ......................................................................................................


This add-in works the same as the List Query Fields add-in, except that it lists tables and their
fields instead of queries and their fields.

Access add-ins, once you have learned the special techniques needed to create them, are a great
way of enhancing your Access databases with extra functionality, even supporting multiple versions
of Access.

Summary ..........................................................................................................................


This chapter dealt with creating Access add-ins in the Access 2007 (.accda) library database format
(you can use the same techniques to create add-ins in the older .mda format for use with databases
created in previous Access database formats as well as Access 2007). Access add-ins let you encap-
sulate a set of database objects (primarily code and forms), for use in any Access database, as a way
of adding extra functionality to a database without the need to manually import objects into any
database where you need the functionality.

The next chapter covers using Ribbon XML to work with the Access ribbon, in Access add-ins as
well as other types of add-ins.

Part III Adding More Functionality to Office

Free download pdf