Properties Window

The Properties Window is found directly below the Project Explorer window. It displays the properties for the object currently highlighted in the Project Explorer. If the Project Explorer is not visible when you open the Microsoft Visual Basic window, you can make it visible by selecting Properties Window under the View menu.

By Admin

Objects in Project Explorer

You might assume that all of the Forms, Reports, and Modules that you create will automatically appear in the Project Explorer. However, this is not true. The VBA environment will only know about the objects if you tag them as "having a module".

By Admin

Designing a Module

Accessing the Visual Basic Window In order to access the VBA environment, press Alt-F11 while your Access database file is open to access the Microsoft Visual Basic window. See the example below.

By Admin

Code Window

The Code window is found to the right of the Project Explorer. It displays the VBA code for the object currently highlighted in the Project Explorer. If the Code window is not visible when you open the Microsoft Visual Basic window, you can make it visible by selecting Code under the View menu.

By Admin

Immediate Window

The Immediate Window is located directly below the Code window. It is an essential element of the debugger found within the VBA environment.

By Admin