Special Edition Using Access 97, Second Edition

Chapter 26. Writing Visual Basic for Applications Code

Most Access applications you create require you to write little or no Access Visual Basic for Applications (VBA) code. A few commercial Access applications rely primarily on macros rather than Access VBA code for automating applications. Starting with Access 95, however, Microsoft recommended that Access developers use VBA code instead of macros, with the clear implication that macros may not be supported in future versions of Access. (Access 97 does support macro operations, but the Microsoft documentation states that it does so primarily for backward compatibility.) Short VBA procedures using the DoCmd object usually are sufficient to provide the methods needed by simple applications to ...