Here is a complete list of RunCommand constants with a description of their function where I know what they do.
Both the list in Access Help and the list 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 or Access 2007. 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.
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
Description
Value
acCmdObjBrwFindWholeWordOnly
Toggles the Find Whole Word Only option. Only available when the Object Browser is active
314
acCmdObjBrwGroupMembers
Toggles the Group Members option. Only available when the Object Browser is active
318
acCmdObjBrwHelp
Opens Help on selected item. Only available when the Object Browser is active
316
acCmdObjBrwShowHiddenMembers
Toggles the Show Hidden Members option. Only available when the Object Browser is active
315
acCmdObjBrwViewDefinition
Displays the selected module. Only available when the Object Browser is active
317
acCmdObjectBrowser
Displays the Object Browser
200
acCmdOfficeClipboard
Displays the Office Clipboard or makes it active if already open
488
acCmdOLEDDELinks
Opens the OLE/DDE Links dialog
27
acCmdOLEObjectConvert
Display the Convert dialog
167
acCmdOLEObjectDefaultVerb
Displays OLE object in its native application
57
acCmdOpenDatabase
Displays the open database dialog
25
acCmdOpenHyperlink
Opens the item associated with the hyperlink
326
acCmdOpenNewHyperlink
Opens the item associated with the hyperlink in a new window
327
acCmdOpenSearchPage
Equivalent to pressing the Search the Web button on the Web Toolbar
253
acCmdOpenStartPage
Equivalent to pressing the Start Page button on the Web Toolbar
252
acCmdOpenTable
Opens a table
221
acCmdOpenURL
Equivalent to selecting the Follow Hyperlink option on the Go dropdown on the Web Toolbar
251
acCmdOptions
Opens the Tools Options dialog box. Available in both VBE and non-VBE views
49
acCmdOutdent
Outdents a line of code
206
acCmdOutputToExcel
Exports the selected object to Excel
175
acCmdOutputToRTF
Outputs selected object in RTF format
176
acCmdOutputToText
Saves selected module as a text file with no prompt for file name or
location. Saves in current directory
177
|