O'Reilly logo

Access™ 2007 VBA Programmer's Reference by Armen Stein, Geoffrey Griffith, Rob Cooper, Teresa Hennig

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

4.2. Using the Object Browser

The Object Browser is probably one of the most powerful tools you'll use when writing VBA code. Display it in the VBA Editor by selecting View Object Browser or by clicking F2. The Object Browser, shown in Figure 4-2, has a number of components.

When you load the Object Browser, you can still view the Project Explorer and the Properties window. The Object Browser appears directly over the Code window. You can return to the Code window at any time by selecting View Code. If multiple code windows are open, you can choose Window from the menu and then select the code window that you want, or you can move the cursor to the code window by clicking on F7. The following are some of the Object Browser's components that you'll use most often:

  • The Project/Library box: Shows all the available type libraries. You can choose All Libraries or any available type library from the drop-down box. The type library you choose dictates which objects you can browse with the Object Browser. Later in this chapter, you'll see how to add a type library to your Project.

  • The Search box: Enter search terms and click the Search button (the binoculars icon) to search the selected type libraries for the particular term. Results of your search are displayed in the Search Results pane. ...

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