Access 2016 Advanced
Lesson 10 - Creating Macros
Access 2016
Action
Argument
Description
Enlarges the active window to fill the screen. Reduces the active window to a button on the taskbar. Moves and/or resizes the active window. Opens a message box containing a warning or informative text. Controls the display of database objects in the Navigation Pane. Specifies what happens when an error occurs in a macro. Opens a form in the selected view.
Maximize
None
Minimize
None
MoveSize
Right, Down, Width, Height Message, Beep (req.), Type (req.), Title
MsgBox
NavigateTo
Category, Group
OnError
Go To, Macro name
Form Name (req.), View (req.), Filter Name, Where Condition, Data Mode (req.), Window Mode (req.) Query Name (req.), View (req.), Data Mode (req.) Report Name (req.), View (req.), Filter Name, Where Condition Table Name (req.), View (req.), Data Mode (req.) Object Type (req.), Object Name, Output Format, Output File, Auto Start, Template File
OpenForm
Opens a query in the selected view.
OpenQuery
OpenReport
Opens a report in the selected view.
Opens a table in the selected view. Outputs data in the specified object to Excel text (.XLSX), rich-text (.RTF), or MS-DOS text (.TXT). Removes any temporary variables created with the SetTempVar action. Removes a single temporary variable created with the SetTempVar action. Quits Access.
OpenTable
OutputTo
Quit
Options (req)
RemoveAllTempVar s
None
RemoveTempVar
None
RepaintObject
Object Type, Object Name Completes any pending
screen updates for the active or specified object.
Page 108
OFFICEPRO, Inc.
Made with FlippingBook - Online magazine maker