O'Reilly logo

Beginning Access™ 2007 VBA by Denise Gosnell

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

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.

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