Access.2007.VBA.Bibl..

List Query Fields ....................................................................................................

This command fills a table with the names of select queries (omitting those whose prefixes are on

the Exclude list), and their field names, and offers to print a report based on that table. The table is

shown in Figure 14.23.

Only select queries will be listed. Although queries of other types (action queries) are

listed by name in the QueryDefs collection, they have no fields to list.

FIGURE 14.23

A table filled with query names and fields.

Note the Expr1008 field name, indicating that the same field is included in the query twice. The

fields in the table are listed in the order that they occur in the query in design view; the report

based on this table gives an alphabetical listing, as shown in Figure 14.24.

The table and report are stored in the calling database, and thus they can be opened later without

re-running the menu add-in.

NOTENOTE

Creating Access Add-ins 14