Access 2002 Programming by Example

Chapter 9. Macros, Modules, and Messages

In Chapter 7, “Exploring Objects,” you learned about objects. In Chapter 8, “Writing Your Own Visual Basic for Applications Code,” you were introduced to writing VBA code using functions. This chapter combines VBA and objects to show how they interact. A common database task is opening database objects such as tables, forms, and reports. These repetitive tasks can be automated using code.

Macros can also automate repetitive tasks, such as opening forms and printing reports, and creating them is easier than writing code. Because you usually set arguments for macros from a list of selections in the Macro window, you don’t have to rely on remembering a complex syntax. In this chapter, you discover how to ...