Chapter 3. Using Variables, Constants, and Data Types

IN THIS CHAPTER

Declaring Variables and Constants 25

VBA Data Types 28

Referencing Syntax 31

Case Study: Using Form References 32

Declaring Variables and Constants

VBA is a programming language and, like all programming languages (even like any spoken language), VBA has its rules of grammar. These rules are generally called syntax. As in any programming language, though somewhat unlike spoken languages, you must be precise in following the syntax and using the language’s components. Computers are actually pretty dumb machines; they can do only what they are told to do. The instructions they are given must be ones they have been taught to understand. If you aren’t precise in your use of syntax, ...

Get Microsoft® Office Access 2007 VBA now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.