Project Explorer in VBA Environment in MS Access

Project Explorer in VBA Environment in MS Access

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

Project Explorer

The Microsoft Visual Basic window displays your VBA environment:

image 118
Project Explorer in VBA Environment in MS Access

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

image 119
Project Explorer in VBA Environment in MS Access 4

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 are two “Microsoft Access Class Objects” – form called frmProducts and a report called rptProducts. 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.

image 121
Project Explorer in VBA Environment in MS Access 5