Share this Page URL

Chapter 7. VBA: An Introduction > Tools for Working in the Visual Basic Editor - Pg. 276

VBA: An Introduction 276 In the list shown in Figure 7.14, all the constant names begin with ac . All VBA constants are prefixed with vb , all Data Access Object constants are prefixed with db , and all constants that are part of the Access language are prefixed with ac . To view the Visual Basic language constants, select VBA from the Project/Library drop-down list and Constants from the Classes list box. If the project you are working with has a reference to the ADO library, you can view these constants by selecting ADODB from the Project/Library drop-down list. Click <globals>. A list of the ADODB constants appears (these constants have the prefix ad ). Another way to view constants is within the context of the parameter you're working with in the Code window. Right-click the name of a parameter and select List Constants to display the constants associated with the parameter. Tools for Working in the Visual Basic Editor Effectively using the tips and tricks of the trade, many of which are highlighted in this chapter, can save you hours of time. These tricks help you to navigate around the coding environment, as well as to modify your code quickly and easily. They include the capability to easily zoom to a user- defined procedure, search and replace within modules, get help on VBA functions and commands, and split the Code window so that two procedures can be viewed simultaneously. The Access 97, Access 2000, Access 2002, and Access 2003 development environments are better than those of their predecessors. Several features have been added to make coding easier and more pleasant for you. These enhancements include the capability to do the following: · · · List properties and methods List constants Get quick information on a command or function