Visual Basic Versus Macros

In the early versions of Access, the programming environment was Access Basic; however, in recent years VBA replaced Access Basic, becoming the standard for Office applications such as Access, Excel, and PowerPoint. This uniformity provides the added benefit of only having to learn one programming language across multiple applications. However, keep in mind that you need to include the library references for the various applications that need to be incorporated into the program.

Both Visual Basic and macros are powerful tools to help you automate your Microsoft Access applications, but which one should you use? Both macros and modules can automate repetitive tasks. They both can access forms and reports and be attached ...

Get Access 2002 Programming by Example now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.