DatabaseLessons.com

'Serving the Microsoft® Access
Community since 1997'

News/Blog
Tables
Queries
Forms
Reports
Modules
Miscellaneous
Subscribe
Free Samples
Videos
Services
Links
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