O'Reilly logo

Special Edition Using Access 97, Second Edition by Roger Jennings

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Converting Access Macros to VBA Code

Many existing Access applications make extensive use of macros to automate form and report operations. You can use Access 97's macro-to-VBA code conversion feature to change all but AutoExec and menu macros to Access VBA procedures. Converting macros to VBA code aids in learning VBA programming in much the same manner as recording Excel 97 or Word 97 macros and then examining the resulting VBA code. The Wildfeeds application (28_wild.mdb), used in this conversion example, began as an Access 2.0 demonstration of the power of Access macros. Wildfeeds imports a fixed-width text file, Wildfeed.txt, that lists unscheduled satellite video programming available to C-band dish owners. Wildfeeds also demonstrates ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required