CONTROLLING CODE WITH CONDITIONAL COMPILATION COMMANDS

Although Accessdoesn't create true executables, it does compile the VBA code to a level lower than the Visual Basic language the developer works with. This compiled code is called pseudocode (also known as P-code). When compiling P-code, certain commands, such as comments, are stripped out to optimize the code.

By using conditional compilation directives, you can include or exclude code sections in the final compiled code. This is different from using just If..Endif to skip over parts of code while it's running. Access literally strips the section of code that's surrounded by the directives. One of the things this means is that you must know which lines of code you won't need at runtime. ...

Get F. Scott Barker's Microsoft® Access 2000 Power Programming 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.