Programming Access RunCommand in Visual Basic
Every menu item in Microsoft Access has an associated RunCommand argument. This menuitems can therefore be run from within Access Visual Basic. You can’t use the RunCommand method to run a command on a custom menu. You can only use it with built-in menus.
The RunCommand method replaces the DoMenuItem method of the DoCmd object.
There is some overlap between DoCmd and RunCommand actions. The DoCmd method often gives you more control over equivalent RunCommand methods.
(note: we will be adding definitions and descriptions of the functions for each RunCommand option in future updates of this page)
RunCommand AcCommand Constants with numeric equivalent
Docmd.RunCommand acCmdAboutMicrosoftAccess caused the Microsoft Access about box to open
Docmd.RunCommand acCmdAddInManager causes the COM add in manager to popup
Docmd.RunCommand acCmdAddToNewGroup is not available at run time – unable to get this command to function
Docmd.RunCommandacCmdAddWatch not available at runtime.
More RunCommand Method Examples:
Access Database Security Alternative
RunCommand acCmdSaveRecord ‘ ‘ set global access level to failsafe no access then lookup access level ‘ GBL_Access_Level = “X” …
NotInList Event in Microsoft Access
RunCommand acCmdSaveRecord Form_F_Trds_Unbnd.Accnt_Name_Entry.Requery Form_F_Trds_Unbnd.Accnt_Number_Combo.Requery ‘ Form_F_Trds_Unbnd.Accnt_ID = Me…
Microsoft Office VBA, MS Access 2003, 2007, 2010, 2013, 2016