Action Constants

Action Constants

See Also

You can use these constants when you use Visual Basic to run a method of the DoCmd object. Using these constants with a method of the DoCmd object is the same as running the corresponding action in a macro. Note that the DoMenuItem method is obsolete; you should use the RunCommand method and its associated constants in Microsoft Access 2000 instead. Constants listed below with an asterisk (*) have been replaced with other constants, but will still work for the method or methods listed.

DoCmd object constants Used with
acActiveDataObject GoToRecord
acAdd OpenQuery, OpenTable, OpenStoredProcedure, OpenView
acAll FindRecord
acAnywhere FindRecord
acCopy DoMenuItem
acCurrent FindRecord
acCut DoMenuItem
acDiagram Close, CopyObject, DeleteObject, Rename, RepaintObject, Save, SelectObject, TransferDatabase
acDataAccessPage Close, CopyObject, DeleteObject, Rename, RepaintObject, Save, SelectObject, TransferDatabase
acDataAccessPageBrowse OpenDataAccessPage
acDataAccessPageDesign OpenDataAccessPage
acDataForm GoToRecord
acDataQuery GoToRecord
acDataServerView GoToRecord
acDataStoredProcedure GoToRecord
acDataTable GoToRecord
acDefault Close, CopyObject, DeleteObject, Rename, RepaintObject, Save,SelectObject
acDelete DoMenuItem
acDesign OpenForm
acDialog OpenForm
acDown FindRecord
acDraft PrintOut
acEdit OpenQuery, OpenTable, OpenStoredProcedure, OpenView
acEditMenu DoMenuItem
acEntire FindRecord
acExit* Quit (DoCmd object), Quit (Application object)
acExport TransferDatabase, TransferSpreadsheet
acExportDelim TransferText
acExportFixed TransferText
acExportHTML TransferText
acExportMerge TransferText
acFile DoMenuItem
acFirst GoToRecord
acFilterNormal ApplyFilter
acForm Close, CopyObject, DeleteObject, Rename, RepaintObject, Save, SelectObject, TransferDatabase
acFormAdd OpenForm
acFormatASP OutputTo
acFormatDAP OutputTo, SendObject
acFormatHTML OutputTo, SendObject
acFormatIIS OutputTo
acFormatRTF OutputTo, SendObject
acFormatSNP OutputTo
acFormatTXT OutputTo, SendObject
acFormatXLS OutputTo, SendObject
acFormBar DoMenuItem
acFormDS OpenForm
acFormEdit OpenForm
acFormPropertySettings OpenForm
acFormReadOnly OpenForm
acGoTo GoToRecord
acHidden OpenForm
acHigh PrintOut
acIcon OpenForm
acImport TransferDatabase, TransferSpreadsheet
acImportDelim TransferText
acImportFixed TransferText
acImportHTML TransferText
acLast GoToRecord
acLink TransferDatabase, TransferSpreadsheet
acLinkDelim TransferText
acLinkFixed TransferText
acLinkHTML TransferText
acLow PrintOut
acMacro Close, CopyObject, DeleteObject, Rename, RepaintObject, Save, SelectObject, TransferDatabase
acMedium PrintOut
acMenuCheck SetMenuItem
acMenuGray SetMenuItem
acMenuUncheck SetMenuItem
acMenuUngray SetMenuItem
acMenuVer1X DoMenuItem
acMenuVer20 DoMenuItem
acMenuVer70 DoMenuItem
acModule Close, CopyObject, DeleteObject, Rename, RepaintObject, Save, SelectObject, TransferDatabase
acNew DoMenuItem
acNewRec GoToRecord
acNext GoToRecord
acNormal OpenForm
acObject DoMenuItem
acObjectUpdate DoMenuItem
acObjectVerb DoMenuItem
acOutputDataAccessPage OutputTo
acOutputForm OutputTo
acOutputModule OutputTo
acOutputQuery OutputTo
acOutputReport OutputTo
acOutputTable OutputTo
acPages PrintOut
acPaste DoMenuItem
acPreview OpenForm
acPrevious GoToRecord
acPrintAll PrintOut
acPrompt* Close, Quit (DoCmd object), Quit (Application object)
acQuery Close, CopyObject, DeleteObject, Rename, RepaintObject, Save, SelectObject, TransferDatabase
acQuitPrompt Quit (DoCmd object), Quit (Application object)
acQuitSaveAll Quit (DoCmd object), Quit (Application object)
acQuitSaveNone Quit (DoCmd object), Quit (Application object)
acReadOnly OpenQuery, OpenTable, OpenStoredProcedure, OpenView
acRecordsMenu DoMenuItem
acRefresh DoMenuItem
acReport Close, CopyObject, DeleteObject, Rename, RepaintObject, Save, SelectObject, TransferDatabase
acSaveForm DoMenuItem
acSaveFormAs DoMenuItem
acSave* Quit (DoCmd object), Quit (Application object)
acSaveNo Close
acSavePrompt Close
acSaveRecord DoMenuItem
acSaveYes Close
acSearchAll FindRecord
acSelectAllRecords DoMenuItem
acSelection PrintOut
acSelectRecord DoMenuItem
acSendDataAccessPage SendObject
acSendForm SendObject
acSendModule SendObject
acSendNoObject SendObject
acSendQuery SendObject
acSendReport SendObject
acSendTable SendObject
acServerFilter ApplyFilter
acServerView Close, CopyObject, DeleteObject, Rename, RepaintObject, Save, SelectObject, TransferDatabase
acSpreadsheetTypeExcel3 TransferSpreadsheet
acSpreadsheetTypeExcel4 TransferSpreadsheet
acSpreadsheetTypeExcel5 TransferSpreadsheet
acSpreadsheetTypeExcel7 TransferSpreadsheet
acSpreadsheetTypeExcel8 TransferSpreadsheet
acSpreadsheetTypeExcel9 TransferSpreadsheet
acSpreadsheetTypeLotusWK1 TransferSpreadsheet
acSpreadsheetTypeLotusWK3 TransferSpreadsheet
acSpreadsheetTypeLotusWK4 TransferSpreadsheet
acSpreadsheetTypeLotusWJ2 — Japanese version only TransferSpreadsheet
acStart FindRecord
acStoredProcedure Close, CopyObject, DeleteObject, Rename, RepaintObject, Save, SelectObject, TransferDatabase
acTable Close, CopyObject, DeleteObject, Rename, RepaintObject, Save, SelectObject, TransferDatabase
acToolbarNo ShowToolbar
acToolbarWhereApprop ShowToolbar
acToolbarYes ShowToolbar
acUndo DoMenuItem
acUp FindRecord
acViewDesign OpenQuery, OpenReport, OpenStoredProcedure, OpenTable, OpenView
acViewNormal OpenQuery, OpenReport, OpenStoredProcedure, OpenTable, OpenView
acViewPreview OpenQuery, OpenReport, OpenStoredProcedure, OpenTable, OpenView
acWindowNormal OpenForm