Microsoft Access 2010 Bible

Part II: Programming Microsoft Access

386

FIGURE 10.5

Examples of Command Button Wizard buttons

FIGURE 10.6

The Go To First Record button’s On Click procedure

Creating VBA Programs

Access has a wide variety of tools that enable you to work with tables, queries, forms, and reports

without ever having to write a single line of code. At some point, you might begin building more

sophisticated applications. You might want to “bulletproof” your applications by providing more

intensive data-entry validation or implementing better error handling.

Some operations can’t be accomplished through the user interface, even with macros. You might find

yourself saying, “I wish I had a way to.. .” or “There just has to be a function that will let me... .”

At other times, you find that you’re continually putting the same formula or expression in a query or