Microsoft® Access® 2010 VBA Programming Inside Out

Chapter 3. Understanding the VBA Language Features

• Using Built-In Functions

• Domain Functions

• SQL and Embedded Quotes

• Objects and Collections

• Creating Maintainable Code

• VBA and Macros

• Error Handling

In Chapter 2, we focused on the core Microsoft VBA language structures that deal with constants, variables, procedures, and controlling the flow of program logic. In this chapter, you look at specific language features, including the use of built-in functions and working with SQL in code.

You will also see how to build upon our structural understanding of the VBA language by incorporating error handling and planning to develop code to improve the maintainability of your applications.

After reading this chapter, you will:

• Be able to use the built-in functions ...