O'Reilly logo

Special Edition Using Access 97, Second Edition by Roger Jennings

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating VBA Object Base Names

When creating VBA object base names, remember that the base name must be descriptive even in the absence of its tag. For some programmers, the syntax Dim I As Integer for a loop variable is quite acceptable. Within LNC, however, the variable I would become iintLoop. Single-character variable names, especially without tags, are not allowed. Instead, create a list of short and standardized work variables to handle common daily needs. The following sections describe the LNC rules for creating VBA object base names.

Rules for Base Names

Creating VBA object base names involves following the same rules listed earlier for creating database object base names:

  • Spaces are not allowed in any object name.

  • Object names begin ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required