VBA is not a scripting language. It compiles. As such, it has compilation arguments, which can be changed through code or manually. In MS Access you may find these here:
VBEditor>Tools>VBA Project>Database Properties:
If you want to use them for some debugging, this is the way to change them through code:
|
1 |
Application.SetOption "Conditional Compilation Arguments","A=4:B=10" |
And this is how you get them:
|
1 |
Application.GetOption("Conditional Compilation Arguments") |
Once you use them, you can refer to them like this for debugging reasons:
|
1 2 3 4 5 6 7 8 9 |
Sub TestMe() #If A = 1 Then Debug.Print "a is 1" #Else Debug.Print "a is not 1" #End If End Sub |
Cheers!