'Serving the Microsoft® Access
Community since 1997'

Free Samples
About Us



Why Not Macros

Macros are not as powerful or as easy to debug as VBA, thus i do NOT recommend their use.

  • Once you are familiar with VBA, you can use your VBA knowledge in other applications, as well as in Access. Have you ever recorded a macro in Microsoft® Excel? What happens? Excel creates some VBA code for you. VBA is even used in some non-Microsoft® programs.
  • There is no facility in Macros for error-trapping. If an error occurs, your program just stops. With VBA, you can perform error-trapping and handle the errors so that your Access application stops gracefully.
  • When I write VBA code, I take full advantage of the automatic features in the VBA editor. Things like Auto Syntax Check, Auto List, and Debugging tools.

Those are just some of the good reasons to abandon macros in favour of VBA code.

Please refer to the Modules section of the Access Database Tips site to learn more about writing VBA code.

Note: This web site dedicated to MS Access database users is an independent publication of Richard W. Killey and is not affiliated with, nor has it been authorized, sponsored, or otherwise approved by Microsoft® Corporation.


© 2006, 2007, 2008 Richard W. Killey. All Rights Reserved. - Privacy Policy