Get Help on Access functions, properties, and more

Can't find Help!

"I know there is a topic about the DCount function, but where is it?"

In the past, getting to the Visual Basic for Applications (VBA) reference topics from within Access might have been frustrating, but no longer.

Now, when you are connected to the Internet, you can easily locate help about functions, properties, events, methods, controls, objects, and more.

You can find this help by searching in the Access Help pane or by searching Office Online or the Microsoft Developer Network (MSDN) Library directly. Or, as before, you can open the Visual Basic Editor and search or browse the Table of Contents, or press F1 in an object's property sheet.

Read on for detailed information.

What's changed?

Reference articles about VBA events, functions, methods, objects, collections, properties, controls, and constants are now available on MSDN. We've made it easy for you to find them when you're working in Access 2003 and connected to the Internet — simply search for them in the Access 2003 Help pane.

And now, you can also search for reference articles directly from MSDN or Office Online. You'll find both index topics and topics for individual elements of Access VBA in the Access Help pane or on Office Online.

ShowSee examples of index and individual element topics for Access VBA

You will see two types of topics in the search return set when you search from Access or Office Online.

First, is a set of index topics, such as Collections (shown) and Events, that include links to the individual event or collection articles on MSDN. In this example, clicking the AccessObjectProperties Collection link will open a new browser window and take you to the article on MSDN for that collection.

The Collections topic on Office Online

The second set of topics map to individual topics on MSDN, such as Date function (shown) and Count property.

Clicking the Date function link in this Access Help topic will open a new browser window and take you to the article on MSDN for that function.

The Date function topic on Office Online

For example, if you are connected to Office Online and you search in Access 2003 for date function, you will see the topics Date function, Functions (alphabetical), and Functions (by category) in the search return set.

Open one of the topics, and then locate and click the link Date function inside the topic to navigate to the corresponding article on MSDN. If you would like to go directly these two articles on MSDN, or the overview topic on Office Online, click the following links:

How do I find help about Access VBA reference topics?

There are several ways for you to find help about VBA reference topics.

ShowGet reference help from anywhere within Access and the Visual Basic Editor

Get reference help from within Access    

  • When you are connected to the Internet    You can search for the new articles that are now available on MSDN from within Access. In the Access Help pane, search for help on a specific element. In the search return set, you will see the corresponding index topic, such as Events or Collections. For commonly-used functions and properties, you might see the corresponding topic in the return set. Open the topic, and click the link to navigate to the reference article on MSDN.

To browse the index topics and the individual topics, click Table of Contents on the Access Help pane, and under Programmability, open the Visual Basic Language Reference folder.

  • When you are not connected to the Internet    You will not be able to search for reference topics from within Access. However, you can get to the topics from within the Visual Basic Editor. You can also get context-sensitive help from a property sheet, Object Browser window, and the Visual Basic Editor workspace. For details, see the sections below.

Get reference help from within the Visual Basic Editor    

  • As always, you can search for reference topics on the Visual Basic Help pane, and then open individual Help topics. To browse reference topics, under Table of Contents, expand the Microsoft Access Visual Basic Reference folder.

ShowSearch for the MSDN reference articles directly from Office Online

As mentioned earlier, a set of new topics now available on Office Online will help you find a specific reference article that is on MSDN.

  • Search Office Online    Search for a specific topic, such as allforms collection or beforeupdate event. In the search return set, you will see topics, such as Collections and Events. Open the topic, and then locate and click the link you are interested in to get redirected to the corresponding article on MSDN.
  • Search the MSDN Library for a specific article    To search for a specific article, go to the MSDN Library, and type the name of the element, such as allforms collection, in the Search box, and click Go.

In the Search Results page, you will see the link to the corresponding reference article. To continue with the previous example, you will see the link AllForms Collection (Microsoft Office Access 2003 Visual Basic Reference) in the search result.

Search Results page on MSDN Library

Click the link to see the AllForms Collection reference article.

  • Browse the articles in the MSDN Library    To browse the table of contents, go to MSDN Library, and expand the Office Solutions Development folder. Expand the Microsoft Office folder, then expand the Microsoft Office 2003, VBA Language Reference, and Microsoft Access Visual Basic Reference folders to view the list of reference articles.

Access 2003 Visual Basic Reference on MSDN Library

ShowGet context-sensitive help from a property sheet, the Visual Basic Editor, and the Object Browser

  • Get help from a property sheet    
  1. In Design view, select the object whose property or event you want help on.
  2. Press F4 to display the object's property sheet.
  3. On the All tab, click the property or event.
  4. Press F1.
  • Get help from the Visual Basic Editor workspace    
  1. In the Database window, press ALT+F11 to start the Visual Basic Editor.
  2. On the Insert menu, click Module.
  3. Type the name of the event, function, method, object, collection, or property on which you want to get help.
  4. Place the cursor inside or right after the last character of the string, or select the entire string.
  5. Press F1.
  • Get help from the Object Browser window    
  1. In the Database window, press ALT+F11 to start the Visual Basic Editor.
  2. On the View menu, click Object Browser.
  3. Select the item for which you want help, and press F1.
 
 
Applies to:
Access 2003