Running Macro Actions and Menu Commands

From within Visual Basic, you can execute most of the macro actions that Access provides and any of the built-in menu commands. Only a few of the macro actions have direct Visual Basic equivalents. To execute a macro action or menu command, use the methods of the DoCmd object, described below.

DoCmd Object

Use the methods of the DoCmd object to execute a macro action or menu command from within a Visual Basic procedure.

Syntax

DoCmd.actionmethod [actionargument],...

Notes

Some of the macro actions you’ll commonly execute from Visual Basic include ApplyFilter, Close, DoMenuItem, FindNext and FindRecord (for searching the recordset of the current form and immediately displaying the result), Hourglass, Maximize, ...

Get Microsoft® Office Access 2003 Inside Out 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.