2008-01-02, 염기웅(abc@dbabc.com.jnc)
<참고> 상기한 저자 이메일의 .jnc는 스팸 방지용입니다.
1. 개요
액세스의 기본 기능에 대한 프로그래밍적 도구로 DoCmd.RunCommand 함수가 제공됩니다. 액세스의 기본 기능이라고 하면 데이터시트에서 오름차순으로 정렬한다든지, 입력폼에서 현재 레코드를 삭제한다든지 하는 작업을 말합니다. 액세스에 기본적으로 동작하는 많은 기능들을 프로그램적으로 제어할 때 RunCommand 함수를 사용하면 됩니다.
쉽게 생각해서, 액세스에서 기본적으로 동작하는 기능인데, 프로그램적으로 어떻게 해야할지 모르겠다면 한번쯤 다음 상수를 참고하여 보기 바랍니다. 보다 자세한 RunCommand 함수에 대한 사용법은 액세스 도움말을 참고하시구요.
2. 상수
acCmdAboutMicrosoftAccess
acCmdAddInManager
acCmdAddToNewGroup
acCmdAddWatch
acCmdAdvancedFilterSort
acCmdAlignBottom
acCmdAlignCenter
acCmdAlignLeft
acCmdAlignmentAndSizing
acCmdAlignMiddle
acCmdAlignRight
acCmdAlignToGrid
acCmdAlignTop
acCmdAlignToShortest
acCmdAlignToTallest
acCmdAnalyzePerformance
acCmdAnalyzeTable
acCmdAnswerWizard
acCmdApplyDefault
acCmdApplyFilterSort
acCmdAppMaximize
acCmdAppMinimize
acCmdAppMove
acCmdAppRestore
acCmdAppSize
acCmdArrangeIconsAuto
acCmdArrangeIconsByCreated
acCmdArrangeIconsByModified
acCmdArrangeIconsByName
acCmdArrangeIconsByType
acCmdAutoCorrect
acCmdAutoDial
acCmdAutoFormat
acCmdBackgroundPicture
acCmdBackgroundSound
acCmdBackup
acCmdBookmarksClearAll
acCmdBookmarksNext
acCmdBookmarksPrevious
acCmdBookmarksToggle
acCmdBringToFront
acCmdCallStack
acCmdChangeToCheckBox
acCmdChangeToComboBox
acCmdChangeToCommandButton
acCmdChangeToImage
acCmdChangeToLabel
acCmdChangeToListBox
acCmdChangeToOptionButton
acCmdChangeToTextBox
acCmdChangeToToggleButton
acCmdChartSortAscByTotal
acCmdChartSortDescByTotal
acCmdClearAll
acCmdClearAllBreakpoints
acCmdClearGrid
acCmdClearHyperlink
acCmdClearItemDefaults
acCmdClose
acCmdCloseWindow
acCmdColumnWidth
acCmdCompactDatabase
acCmdCompileAllModules
acCmdCompileAndSaveAllModules
acCmdCompileLoadedModules
acCmdCompleteWord
acCmdConditionalFormatting
acCmdConnection
acCmdControlWizardsToggle
acCmdConvertDatabase
acCmdConvertMacrosToVisualBasic
acCmdCopy
acCmdCopyDatabaseFile
acCmdCopyHyperlink
acCmdCreateMenuFromMacro
acCmdCreateRelationship
acCmdCreateReplica
acCmdCreateShortcut
acCmdCreateShortcutMenuFromMacro
acCmdCreateToolbarFromMacro
acCmdCut
acCmdDataAccessPageAddToPage
acCmdDataAccessPageBrowse
acCmdDataAccessPageDesignView
acCmdDataAccessPageFieldListRefresh
acCmdDatabaseProperties
acCmdDatabaseSplitter
acCmdDataEntry
acCmdDataOutline
acCmdDatasheetView
acCmdDateAndTime
acCmdDebugWindow
acCmdDelete
acCmdDeleteGroup
acCmdDeletePage
acCmdDeleteQueryColumn
acCmdDeleteRecord
acCmdDeleteRows
acCmdDeleteTab
acCmdDeleteTable
acCmdDeleteTableColumn
acCmdDeleteWatch
acCmdDemote
acCmdDesignView
acCmdDiagramAddRelatedTables
acCmdDiagramAutosizeSelectedTables
acCmdDiagramDeleteRelationship
acCmdDiagramLayoutDiagram
acCmdDiagramLayoutSelection
acCmdDiagramModifyUserDefinedView
acCmdDiagramNewLabel
acCmdDiagramNewTable
acCmdDiagramRecalculatePageBreaks
acCmdDiagramShowRelationshipLabels
acCmdDiagramViewPageBreaks
acCmdDocMaximize
acCmdDocMinimize
acCmdDocMove
acCmdDocRestore
acCmdDocSize
acCmdDocumenter
acCmdDropSQLDatabase
acCmdDuplicate
acCmdEditHyperlink
acCmdEditingAllowed
acCmdEditRelationship
acCmdEditTriggers
acCmdEditWatch
acCmdEncryptDecryptDatabase
acCmdEnd
acCmdExit
acCmdExport
acCmdFavoritesAddTo
acCmdFavoritesOpen
acCmdFieldList
acCmdFilterByForm
acCmdFilterBySelection
acCmdFilterExcludingSelection
acCmdFind
acCmdFindNext
acCmdFindNextWordUnderCursor
acCmdFindPrevious
acCmdFindPrevWordUnderCursor
acCmdFitToWindow
acCmdFont
acCmdFormatCells
acCmdFormHdrFtr
acCmdFormView
acCmdFreezeColumn
acCmdGoBack
acCmdGoContinue
acCmdGoForward
acCmdGroupByTable
acCmdGroupControls
acCmdHideColumns
acCmdHidePane
acCmdHideTable
acCmdHorizontalSpacingDecrease
acCmdHorizontalSpacingIncrease
acCmdHorizontalSpacingMakeEqual
acCmdHyperlinkDisplayText
acCmdImport
acCmdIndent
acCmdIndexes
acCmdInsertActiveXControl
acCmdInsertChart
acCmdInsertFile
acCmdInsertFileIntoModule
acCmdInsertHyperlink
acCmdInsertLookupColumn
acCmdInsertLookupField
acCmdInsertMovieFromFile
acCmdInsertObject
acCmdInsertPage
acCmdInsertPicture
acCmdInsertPivotTable
acCmdInsertProcedure
acCmdInsertQueryColumn
acCmdInsertRows
acCmdInsertSpreadsheet
acCmdInsertSubdatasheet
acCmdInsertTableColumn
acCmdInsertUnboundSection
acCmdInvokeBuilder
acCmdJoinProperties
acCmdLastPosition
acCmdLayoutPreview
acCmdLineUpIcons
acCmdLinkedTableManager
acCmdLinkTables
acCmdListConstants
acCmdLoadFromQuery
acCmdMacroConditions
acCmdMacroNames
acCmdMakeMDEFile
acCmdMaximiumRecords
acCmdMicrosoftAccessHelpTopics
acCmdMicrosoftOnTheWeb
acCmdMicrosoftScriptEditor
acCmdMoreWindows
acCmdNewDatabase
acCmdNewGroup
acCmdNewObjectAutoForm
acCmdNewObjectAutoReport
acCmdNewObjectClassModule
acCmdNewObjectDataAccessPage
acCmdNewObjectDiagram
acCmdNewObjectForm
acCmdNewObjectFunction
acCmdNewObjectMacro
acCmdNewObjectModule
acCmdNewObjectQuery
acCmdNewObjectReport
acCmdNewObjectStoredProcedure
acCmdNewObjectTable
acCmdNewObjectView
acCmdObjBrwFindWholeWordOnly
acCmdObjBrwGroupMembers
acCmdObjBrwHelp
acCmdObjBrwShowHiddenMembers
acCmdObjBrwViewDefinition
acCmdObjectBrowser
acCmdOfficeClipboard
acCmdOLEDDELinks
acCmdOLEObjectConvert
acCmdOLEObjectDefaultVerb
acCmdOpenDatabase
acCmdOpenHyperlink
acCmdOpenNewHyperlink
acCmdOpenSearchPage
acCmdOpenStartPage
acCmdOpenTable
acCmdOpenURL
acCmdOptions
acCmdOutdent
acCmdOutputToExcel
acCmdOutputToRTF
acCmdOutputToText
acCmdPageHdrFtr
acCmdPageNumber
acCmdPageProperties
acCmdPageSetup
acCmdParameterInfo
acCmdPartialReplicaWizard
acCmdPaste
acCmdPasteAppend
acCmdPasteAsHyperlink
acCmdPasteSpecial
acCmdPivotAutoAverage
acCmdPivotAutoCount
acCmdPivotAutoFilter
acCmdPivotAutoMax
acCmdPivotAutoMin
acCmdPivotAutoStdDev
acCmdPivotAutoStdDevP
acCmdPivotAutoSum
acCmdPivotAutoVar
acCmdPivotAutoVarP
acCmdPivotChartByRowByColumn
acCmdPivotChartDrillInto
acCmdPivotChartDrillOut
acCmdPivotChartMultiplePlots
acCmdPivotChartMultiplePlotsUnifiedScale
acCmdPivotChartShowLegend
acCmdPivotChartType
acCmdPivotChartUndo
acCmdPivotChartView
acCmdPivotCollapse
acCmdPivotDelete
acCmdPivotDropAreas
acCmdPivotExpand
acCmdPivotRefresh
acCmdPivotShowAll
acCmdPivotShowBottom1
acCmdPivotShowBottom10
acCmdPivotShowBottom10Percent
acCmdPivotShowBottom1Percent
acCmdPivotShowBottom2
acCmdPivotShowBottom25
acCmdPivotShowBottom25Percent
acCmdPivotShowBottom2Percent
acCmdPivotShowBottom5
acCmdPivotShowBottom5Percent
acCmdPivotShowBottomOther
acCmdPivotShowTop1
acCmdPivotShowTop10
acCmdPivotShowTop10Percent
acCmdPivotShowTop1Percent
acCmdPivotShowTop2
acCmdPivotShowTop25
acCmdPivotShowTop25Percent
acCmdPivotShowTop2Percent
acCmdPivotShowTop5
acCmdPivotShowTop5Percent
acCmdPivotShowTopOther
acCmdPivotTableClearCustomOrdering
acCmdPivotTableCreateCalcField
acCmdPivotTableCreateCalcTotal
acCmdPivotTableDemote
acCmdPivotTableExpandIndicators
acCmdPivotTableExportToExcel
acCmdPivotTableFilterBySelection
acCmdPivotTableGroupItems
acCmdPivotTableHideDetails
acCmdPivotTableMoveToColumnArea
acCmdPivotTableMoveToDetailArea
acCmdPivotTableMoveToFilterArea
acCmdPivotTableMoveToRowArea
acCmdPivotTablePercentColumnTotal
acCmdPivotTablePercentGrandTotal
acCmdPivotTablePercentParentColumnItem
acCmdPivotTablePercentParentRowItem
acCmdPivotTablePercentRowTotal
acCmdPivotTablePromote
acCmdPivotTableRemove
acCmdPivotTableShowAsNormal
acCmdPivotTableShowDetails
acCmdPivotTableSubtotal
acCmdPivotTableUngroupItems
acCmdPivotTableView
acCmdPreviewEightPages
acCmdPreviewFourPages
acCmdPreviewOnePage
acCmdPreviewTwelvePages
acCmdPreviewTwoPages
acCmdPrimaryKey
acCmdPrint
acCmdPrintPreview
acCmdPrintRelationships
acCmdProcedureDefinition
acCmdPromote
acCmdProperties
acCmdPublish
acCmdPublishDefaults
acCmdQueryAddToOutput
acCmdQueryGroupBy
acCmdQueryParameters
acCmdQueryTotals
acCmdQueryTypeAppend
acCmdQueryTypeCrosstab
acCmdQueryTypeDelete
acCmdQueryTypeMakeTable
acCmdQueryTypeSelect
acCmdQueryTypeSQLDataDefinition
acCmdQueryTypeSQLPassThrough
acCmdQueryTypeSQLUnion
acCmdQueryTypeUpdate
acCmdQuickInfo
acCmdQuickPrint
acCmdQuickWatch
acCmdRecordsGoToFirst
acCmdRecordsGoToLast
acCmdRecordsGoToNew
acCmdRecordsGoToNext
acCmdRecordsGoToPrevious
acCmdRecoverDesignMaster
acCmdRedo
acCmdReferences
acCmdRefresh
acCmdRefreshPage
acCmdRegisterActiveXControls
acCmdRelationships
acCmdRemove
acCmdRemoveFilterSort
acCmdRemoveTable
acCmdRename
acCmdRenameColumn
acCmdRenameGroup
acCmdRepairDatabase
acCmdReplace
acCmdReportHdrFtr
acCmdReset
acCmdResolveConflicts
acCmdRestore
acCmdRowHeight
acCmdRun
acCmdRunMacro
acCmdRunOpenMacro
acCmdSave
acCmdSaveAllModules
acCmdSaveAllRecords
acCmdSaveAs
acCmdSaveAsASP
acCmdSaveAsDataAccessPage
acCmdSaveAsHTML
acCmdSaveAsIDC
acCmdSaveAsQuery
acCmdSaveAsReport
acCmdSaveLayout
acCmdSaveModuleAsText
acCmdSaveRecord
acCmdSelectAll
acCmdSelectAllRecords
acCmdSelectDataAccessPage
acCmdSelectForm
acCmdSelectRecord
acCmdSelectReport
acCmdSend
acCmdSendToBack
acCmdServerFilterByForm
acCmdServerProperties
acCmdSetControlDefaults
acCmdSetDatabasePassword
acCmdSetNextStatement
acCmdShowAllRelationships
acCmdShowDirectRelationships
acCmdShowEnvelope
acCmdShowMembers
acCmdShowNextStatement
acCmdShowOnlyWebToolbar
acCmdShowTable
acCmdSingleStep
acCmdSizeToFit
acCmdSizeToFitForm
acCmdSizeToGrid
acCmdSizeToNarrowest
acCmdSizeToWidest
acCmdSnapToGrid
acCmdSortAscending
acCmdSortDescending
acCmdSortingAndGrouping
acCmdSpeech
acCmdSpelling
acCmdSQLView
acCmdStartupProperties
acCmdStepInto
acCmdStepOut
acCmdStepOver
acCmdStepToCursor
acCmdStopLoadingPage
acCmdSubdatasheetCollapseAll
acCmdSubdatasheetExpandAll
acCmdSubdatasheetRemove
acCmdSubformDatasheet
acCmdSubformDatasheetView
acCmdSubformFormView
acCmdSubformInNewWindow
acCmdSubformPivotChartView
acCmdSubformPivotTableView
acCmdSwitchboardManager
acCmdSynchronizeNow
acCmdTabControlPageOrder
acCmdTableAddTable
acCmdTableCustomView
acCmdTableNames
acCmdTabOrder
acCmdTestValidationRules
acCmdTileHorizontally
acCmdTileVertically
acCmdToggleBreakpoint
acCmdToggleFilter
acCmdToolbarControlProperties
acCmdToolbarsCustomize
acCmdTransferSQLDatabase
acCmdTransparentBackground
acCmdTransparentBorder
acCmdUndo
acCmdUndoAllRecords
acCmdUnfreezeAllColumns
acCmdUngroupControls
acCmdUnhideColumns
acCmdUpsizingWizard
acCmdUserAndGroupAccounts
acCmdUserAndGroupPermissions
acCmdUserLevelSecurityWizard
acCmdVerticalSpacingDecrease
acCmdVerticalSpacingIncrease
acCmdVerticalSpacingMakeEqual
acCmdViewCode
acCmdViewDataAccessPages
acCmdViewDetails
acCmdViewDiagrams
acCmdViewFieldList
acCmdViewForms
acCmdViewFunctions
acCmdViewGrid
acCmdViewLargeIcons
acCmdViewList
acCmdViewMacros
acCmdViewModules
acCmdViewQueries
acCmdViewReports
acCmdViewRuler
acCmdViewShowPaneDiagram
acCmdViewShowPaneGrid
acCmdViewShowPaneSQL
acCmdViewSmallIcons
acCmdViewStoredProcedures
acCmdViewTableColumnNames
acCmdViewTableColumnProperties
acCmdViewTableKeys
acCmdViewTableNameOnly
acCmdViewTables
acCmdViewTableUserView
acCmdViewToolbox
acCmdViewVerifySQL
acCmdViewViews
acCmdVisualBasicEditor
acCmdWebPagePreview
acCmdWebPageProperties
acCmdWebTheme
acCmdWindowArrangeIcons
acCmdWindowCascade
acCmdWindowHide
acCmdWindowSplit
acCmdWindowUnhide
acCmdWordMailMerge
acCmdWorkgroupAdministrator
acCmdZoom10
acCmdZoom100
acCmdZoom1000
acCmdZoom150
acCmdZoom200
acCmdZoom25
acCmdZoom50
acCmdZoom500
acCmdZoom75
acCmdZoomBox
acCmdZoomSelection
