When you are working in Access (not the VBE) and need help with a SQL statement, the natural instinct may be to click Help. In the past, this typically led to a futile search, followed by opening the VBE window and starting the search all over again. With Access 2003, you can get help with your code without opening the VBE. There are several ways to get SQL help from within Access.
□ The most convenient is typically to hit F1: From the SQL view put the cursor on the keyword that you want help with and then hit F1. Voila, the answer to the question!
□ The next most obvious way is to open Access Help and type in the SQL Keywords.
□ Alternatively, open Access Help and type in Aggregate Functions, VBA Functions, or Access Functions.
□ And, there is also Access Help's Table of Contents. This is impressively extensive, especially if it includes online help. You can just keep drilling. There are at least six layers. Now that's organized.
Note: If you're working in an ADP, you'll still need to use the VBE to get help with SQL.
To get help from the Table of Contents, open Access Help and click Table of Contents. Under the Creating and Working with Databases and Objects folder, click Database objects, and then click Queries to display the Microsoft Jet SQL Reference folder. Keep going because there are still at least two more levels. It would take more than a day to study all the material just in this folder alone. Figure 3-8 shows the Table of Contents opened to display Help with Access functions.
It is important to note that the Microsoft Jet SQL Reference folder does not include the links to Data Access Object (DAO) reference topics and examples. It would be a little too confusing to have DAO and ActiveX Data Object (ADO) in the same folder. However, help with DAO is provided in a couple of other folders that are at the bottom of the Table of Contents. Obviously, it would be in the folder Microsoft DAO 3.60. And, it is also in the Microsoft Jet SQL Reference folder that is just below the DAO 3.60 folder.
If you are looking for help with DAO, you need to look in the folders named
Microsoft DAO 3.60 or Microsoft Jet SQL Reference.
Was this article helpful?