AddMenu | |
ApplyFilter | Compare with SetFilter |
Beep | |
BrowseTo | |
CancelEvent | |
ClearMacroError | Resets the MacroError object. |
Close | |
CloseDatabase | Same as File -> Close. |
CopyDatabaseFile | Copies the currently connected to database to a SQL Server database (a database file with the extension .mdf). |
CopyObject | |
DeleteObject | Drop tables etc. |
DoMenuItem | Replaced by Application.RunCommand() and DoCmd.RunCommand() |
Echo | It is recommended to use application.echo instead of doCmd.echo |
FindNext | |
FindRecord | |
GoToControl | |
GoToPage | |
GoToRecord | «Activate» a record. Compare with DoCmd.SearchForRecord. |
Hourglass | |
LockNavigationPane | |
Maximize, Minimize | |
MoveSize | |
NavigateTo | |
OpenDataAccessPage | |
OpenDiagram | |
OpenForm | |
OpenFunction | Opens a user defined function which is defined in SQL Server for viewing in MS Access. |
OpenModule | |
OpenQuery | Compare with runSQL |
OpenReport | |
OpenStoredProcedure | |
OpenTable | |
OpenView | |
OutputTo | Compare with the transfer… methods. |
PrintOut | |
Quit | |
RefreshRecord | |
Rename | |
RepaintObject | |
Requery | |
Restore | |
RunCommand | Runs a built-in command (which is identified with the acCmd* enumeration). |
RunDataMacro | |
RunMacro | |
RunSavedImportExport | |
RunSQL | Execute a DML (aka action query) or DDL statement |
Save | |
SearchForRecord | Compare with DoCmd.GoToRecord |
SelectObject | |
SendObject | |
SetDisplayedCategories | |
SetFilter | Compare with ApplyFilter |
SetMenuItem | |
SetOrderBy | Specify the columns whose values specify the order of records (sort) in the table, form, report or datasheet that is active and has the focus. |
SetParameter | |
SetProperty | |
SetWarnings | Enable or disable warnings |
ShowAllRecords | Remove all applied filters from the active table, query result set or form, that is essentially: show all records. Compare with doCmd.applyFilter, doCmd.setFilter] |
ShowToolbar | |
SingleStep | Stops execution of the currently running macro(?) and opens the Macro Single Step dialog. Compare with the VBA Stop statement Compare with the VBA Stop statement. |
TransferXXX | Export data into or from MS-Access. XXX = Database, SharePointList, Spreadsheet, SQLDatabase or Text |