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 ...

Get Special Edition Using Access 97, Second Edition 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.