![]() |
MS Access FAQ - Macros |
![]() |
![]() |
Preventing the AutoExec Macro |
![]() |
Comments in Macros |
![]() |
Why there's not many questions about macros |
![]() |
How do I prevent the AutoExec Macro from Executing? | ![]() |
![]() |
In Access 2.0 you can hold down the [Shift] Key while the database is loading. In Access 97, you can use the "NOSTARTUP" switch, e.g. MSACCESS.EXE" /NOSTARTUP "C:\database\mydb.mdb" Updated: 21/12/1997 - Trevor Best | ![]() |
![]() |
How do I temporarily comment out a line in a macro? | ![]() |
![]() |
Although macros do not support the REM statement you may be used to from batch files or BASIC, you can achieve a similar effect. Simply activate the Condition column for your macro and enter "False" as the condition for any action you wish to temporarily skip. If there's already a condition column, simply add "False and " to the start of the condition to make it always False. Updated: 17/08/1996 - Trevor Best | ![]() |
![]() |
Why aren't there more questions about macros here? | ![]() |
![]() |
Most professional Access developers tend to use modules rather than macros in their databases. A module can do anything a macro can do and much more except execute automatically at startup and modify menus. The key difference is that modules can be written to trap and cure errors, while any error in a macro brings operations to a halt. Updated: 17/08/1996 - Mike Gunderloy | ![]() |