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

J.2. Access Builders

Access 2007 offers nine builders that will guide developers through a process. You're familiar with the Query Builder. There are also some builders, such as the Color Builder, that are available in other Office programs. In Access 2007, the Field Builder is replaced by table templates and the Color Builder is enhanced to provide the color picker used by other programs.

BuilderDescription
ColorEnhanced to use the color picker used by other programs. In addition to a larger selection of color swatches, it also displays a palette for selecting customized colors.
Edit List ItemsBuilds and edits value lists that are the row source for combo box and list box controls or for lookup fields in tables.
ExpressionCreates expressions for macros, queries, and property sheets.
FieldCreates fields in tables in previous versions. Replaced by table templates in Access 2007.
MacroCreates and edits macros, such as those created when a command button is added to a form or report. Builds both embedded and standalone macros.
ODBC Connection StringCreates the correct syntax for a connection to an ODBC database. Walks users through the process to establish a connection to an external data source.
PictureCreates bitmap images for forms and reports.
QueryCreates the correct syntax for a query.
Smart TagsDisplays a list of available smart tags and their actions. Smart tags enable you to perform tasks within Access that you otherwise would have needed to open other programs to handle. Smart tags ...

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