O'Reilly logo

F. Scott Barker's Microsoft® Access 2000 Power Programming by F. Scott Barker

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

LOOKING AT MACRO-TO-CODE CHANGES

Developers sometimes feel nervous about switching to code because they fear getting themselves into a complex world without all the commands they have available with macros. This is far from true.

Although getting into code can be confusing at first, switching to VBA not only gives you more flexibility, it gives you more control. Most macro commands are covered with the DoCmd object, described in the following section; others either have equivalent commands or aren't needed in code.

Using the DoCmd Object

In code, most of the macro actions can be performed using the DoCmd object. The actions are used as methods that can be called with arguments. Most of the arguments have intrinsic constants, which can be used ...

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