Using the Object Browser and Help System - MS Access

In this section, you will look at how you can configure the behavior of the Help system and the use of the Object Browser as an alternative method for locating help on objects.

Configuring the Help System

VBA has an excellent Help system. To use it, simply click a word that you do not understand, and then press F1. However, it's best to have the Help system set to work with Show Content Only From This Computer; otherwise, many of the help topics might not easily locate help for a particular keyword, function, or method. Figure shows this setting being changed at the bottom of the figure.

With the Help screen open, setting the Help system to Show Content Only From

With the Help screen open, setting the Help system to Show Content Only From

Access comes with an extensive Help system, and by highlighting a keyword in code (for example CurrentDb) and pressing F1, you can display help on the statement or object, as shown in Figure.

Press F1 when you have the cursor on a VBA keyword to locate the keyword

Press F1 when you have the cursor on a VBA keyword to locate the keyword

Working with the Object Browser

As you move into more advanced programming, you will see that when you work with objects outside of the Office suite, getting help by pressing F1 will not always display the help information for the object. In this case, you can use the Object Browser either by using the toolbar or pressing the F2 key. Help is then also available on these external libraries through the object browser.

You can use the object browser to locate objects

You can use the object browser to locate objects

The object browser can be used for code units designed in your application, external referenced programming units, and Office components including Access where we have searched for the text Currentdb.

When you have located an item in the object browser, press F1 to display the help file that describes the object.

When you have located an item in the object browser, press F1 to display the help file that describes the object.


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

MS Access Topics