Examples of using Macro action in English and their translations into Vietnamese
{-}
-
Colloquial
-
Ecclesiastic
-
Computer
The ShowAllRecords macro action doesn't have any arguments.
Each macro is made up of one or more macro actions.
Access macro actions represent only a subset of the commands available in VBA.
In Access web apps, the GoToRecord macro action has only one argument.
To execute macro actions only when certain conditions are true, you use an If block.
The following listdemonstrates some things you can do with the SearchForRecord macro action.
You can use the RunMacro macro action in Access databases to run a macro. .
Note: If you only want to record the date or the time,omit the macro action that you do not need.
Note: The FindNextRecord macro action was renamed from FindNext to FindNextRecord beginning in Access 2010.
Depending on the context you are working in, some macro actions may not be available for use.
You can use this macro action to select the first control(as defined by the form's tab order) on the specified page.
The value of the temporary variable MyVar(created by using the SetTempVar macro action) equals 43.
In Office Access 2007, new features and macro actions have been added to help eliminate the need for code.
If you want to show a particular group on just one form or report, you can set the OnActivate property of the form orreport to the name of a macro that contains a ShowToolbar macro action to show the group.
In Office Access 2007, new features and macro actions have been added to help eliminate the need for code.
Control your PC, application or game can be controlled by voice commands and/ or by the press of a keyboard, mouse button or combinations of it,additionally you can start any of your macros by scheduler, by a macro action, or from an external program.
Select the drop-down list of macro actions below the MessageBox action, and then select CancelEvent.
This condition can be used in conjunction with the ClearMacroError andOnError macro actions to control what happens when an error occurs.
Once you have found the macro action you want, add it to the macro by using one of these methods.
However, this command runs the macro only once,whereas the RunMacro macro action can run a macro as many times as you want.
You can use the ShowToolbar macro action in Access desktop databases to display or hide a group of commands on the Add-Ins tab.
For example, if you are displaying objects sorted by Creation Date andyou use the SetDisplayedCategories macro action to disable the Creation Date option, Access does not switch the Navigation Pane to another category.
You can use this macro action to ensure that all records(including any changed or new records) are displayed for a table, query result set, or form.
If the currently selected text is thesame as the search text at the time the FindNextRecord macro action is carried out, the search begins immediately following the selection, in the same field as the selection, and in the same record.
You can use the RemoveTempVar macro action in Access desktop databases to remove a single temporary variable that you created by using the SetTempVar action. .
For example, suppose that you want a macro action to run only when the value in a text box is greater than or equal to 10.
You can use the FindNextRecord macro action in Access desktop databases to find the next record that meets the criteria specified by the previous FindRecord macro action or the value in the Find and Replace dialog box(on the Home tab, click Find).
The macro then uses the SearchForRecord macro action to find the first record in the table where the Description field equals"Beverages.".
If the object is a form, the SelectObject macro action sets the form's Visible property to Yes and returns the form to the mode set by its form properties(for example, as a modal or pop-up form).
If you run a macro containing the OpenDataAccessPage macro action in a library database, Microsoft Office Access 2007 first looks for the page with this name in the library database, and then in the current database.