A.3. Chapter 3

  1. Properties are characteristics of the object, such as the caption, name, or size. Methods are actions that are taken upon an object, such as setting the focus to the object. Events are triggered by actions taken by the user and the application, such as changes to data, mouse movements, a form opening, and so on. Events allow you to link up your forms and reports with the VBA code that you write so that the code will execute at the appropriate time.

  2. You can set properties and events for a given object from the Properties dialog box in the form or report designer. You can view and manipulate properties, methods, and events from within the code window in the Visual Basic Editor as you type the object name followed by the period. The Object Browser also allows you to view the properties, methods, and events available for a selected object.

  3. The Forms collection of the Application object only works with currently open forms. The AllForms collection of the Application.CurrentProject object allows you to work with all forms in the application.

Get Beginning Access™ 2007 VBA now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.