Full List of All RunCommand Constants

Here is a complete list of RunCommand constants with a description of their function where I know what they do. The list in Access Help and the one obtainable on the Microsoft Web Site are incomplete and contradict one another.

I have colour coded the list dependent on the version in which they first appeared - Access 97, Access 2000, Access XP, Access 2003, Access 2007 or Access 2010. Prior to Access 2007, all later versions of Access recognise the earlier commands. See Known Problems for more details. Some of these were retained for backwards compatibility only. If you spot any errors or can fill the gaps please let me know.

Code Link links to code examples for that constant. Select the start letter, ignoring the acCmd, of the constant.

Select the sixth letter of the acCmdConstant
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Constants starting acCmdO

Constant
Value
Description
acCmdObjBrwFindWholeWordOnly
314
Toggles the Find Whole Word Only option. Only available when the Object Browser is active
acCmdObjBrwGroupMembers
318
Toggles the Group Members option. Only available when the Object Browser is active
acCmdObjBrwHelp
318
Opens Help on selected item. Only available when the Object Browser is active
acCmdObjBrwShowHiddenMembers
315
Toggles the Show Hidden Members option. Only available when the Object Browser is active
acCmdObjBrwViewDefinition
317
Displays the selected module. Only available when the Object Browser is active
Code ExampleacCmdObjectBrowser
200
Displays the Object Browser
acCmdOfficeClipboard
488
Displays the Office Clipboard or makes it active if already open
Code ExampleacCmdOLEDDELinks
27
Opens the OLE/DDE Links dialog
acCmdOLEObjectConvert
167
Display the Convert dialog
Code ExampleacCmdOLEObjectDefaultVerb
57
Displays OLE object in its native application
acCmdOpenDatabase
25
Displays the open database dialog
Code ExampleacCmdOpenHyperlink
326
Opens the item associated with the hyperlink
Code ExampleacCmdOpenNewHyperlink
327
Opens the item associated with the hyperlink in a new window
acCmdOpenSearchPage
253
Equivalent to pressing the Search the Web button on the Web Toolbar
acCmdOpenStartPage
252
Equivalent to pressing the Start Page button on the Web Toolbar
acCmdOpenTable
221
Opens a table
Code ExampleacCmdOpenURL
251
Equivalent to selecting the Follow Hyperlink option on the Go dropdown on the Web Toolbar
Code ExampleacCmdOptions
49
Opens the Tools Options dialog box. Available in both VBE and non-VBE views
acCmdOutdent
206
Outdents a line of code
Code ExampleacCmdOutputToExcel
175
Exports the selected object to Excel
Code ExampleacCmdOutputToRTF
176
Outputs selected object in RTF format
Code ExampleacCmdOutputToText
177
Saves selected module as a text file with no prompt for file name or location. Saves in current directory

© 1998 - 2011 Terry Wickenden TKW Design Site developed, maintained and hosted by TKW Design. This site is best viewed at 1024 x 768. Optimised for Firefox.