totn Access 2007 VBA Environment

MS Access 2007: Project Explorer in VBA Environment

This MSAccess tutorial explains the Project Explorer within the VBA environment in Access 2007 (with screenshots and step-by-step instructions).

Project Explorer

The Microsoft Visual Basic window displays your VBA environment:

Microsoft Access

Next, let's take a few moments to analyze the various sections in the Microsoft Visual Basic window.

Microsoft Access

The Project Explorer can usually be found in the top left portion of the Microsoft Visual Basic window. It is a hierarchical listing of the objects recognized by VBA.

In this example, there is one "Microsoft Access Class Objects" - a form called frmProducts. There is also a Module called Module1.

These are all objects that you've created in your Access database that the VBA environment is aware of. The Project Explorer may not display all of your Access objects.

If the Project Explorer is not visible when you open the Microsoft Visual Basic window, you can make it visible by selecting Project Explorer under the View menu.

Microsoft Access