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.