The Visual Basic Editor VBE

Now that you know how to write event procedures in modules placed behind a form or a report, let's spend some time in the Visual Basic Editor window and become familiar with several of its features. With the tools located in the Visual Basic Editor window, you can:

■ Write your own VBA procedures

■ Create custom forms

■ View and modify object properties

■ Test VBA procedures and locate errors

In addition to accessing the Visual Basic Editor window from the properties sheet of a form or report (while the form or report is in Design view), you can enter the VBA programming environment in any of the following ways: From the Database window, by choosing Tools | Macro | Visual Basic Editor

■ From the keyboard, by pressing Alt+F11

From the Database window, by clicking the Modules button, and then New on the toolbar to create a new standard module, or by double-clicking any existing standard module you want to view

0 0

Post a comment