O'Reilly logo

Microsoft® Access® 2010 In Depth by Roger Jennings

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

30. Handling Events with VBA and Macros

All Windows applications are event-driven, which means that an event, such as a mouse click on a command button or a change in the position of a record pointer, executes individual standalone or embedded macros, or blocks of application programming code. If you elect to use VBA, the majority of the code you write consists of event-handling subprocedures—also called event procedures or event handlers—that are contained within [{Public|Private}] Sub {Form|Report}_[ObjectName_]EventName... End Sub structures of class modules. Class module is the VBA term that describes a container for Access-specific VBA code that’s embedded within a Form or Report container. As mentioned in Chapter 19, “Automating Access ...

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