O'Reilly logo

F. Scott Barker's Microsoft® Access 2000 Power Programming by F. Scott Barker

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

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

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