Creating a Standalone Macro

A standalone macro is a macro that is displayed under the Macro in the Navigation Pane. To create a standalone macro, take the following steps: 1. Click the Create tab. 2. Click Macro in the Macros & Code group. 3. You should be able to see the Macro Designer by now. To add an action, […]

Creating a Standalone Macro

A standalone macro is a macro that is displayed under the Macro in the Navigation Pane.
To create a standalone macro, take the following steps:

1. Click the Create tab.
2. Click Macro in the Macros & Code group.
3. You should be able to see the Macro Designer by now. To add an action, type in the macro action or click on the drop-down menu to display the list from which you choose the action that you want to use.
4. To add more actions to the macro, move to another action row, and then repeat the previous step. Access carries out the actions in the order in which you list them.
5. Click Save when your done.
Create a macro group for several related macros.
1. Click the Create tab.
2. Click Macro in the Macros & Code group.
3. Once the designer is displayed, select Group from the drop-down list.
4. Input the name you want to use for the macro group in the text box.
5. Start adding the actions that you want to use. Input the macro action or use the drop-down list to select an action.
6. Fill in the required information for the action.
7. To add more actions, repeat steps 5 and 6.
8. Click Save.
In previous versions of Access, many usually used functions could not be executed without writing VBA code. With the release of Access 2010, new features and macro actions have been added to help remove the need for code. This makes it less demanding to add functionality to your database and helps make it more secure.

Embedded macros: You can now embed macros in any of the events given by a form, report, or control. An embedded macro is not displayed in the Navigation Pane; it becomes part of the form, report, or control in which it was created. If you make a duplicate of a form, report, or control that has embedded macros, the macros are also present in the duplicate.

Increased security: When the Show All Actions button is not highlighted in the Macro Builder, the only macro actions and Run Command arguments that are accessible for usage are those that do not require trusted status to execute. A macro built with these actions will execute even when the database is in disabled mode. Databases that contain macro actions that are not on the trusted list need to be explicitly granted trusted status.

Error handling and debugging: Access 2010 provides new macro actions, which include On Error and Clear Macro Error, that enable you to run certain actions when errors occur while your macro is running. Moreover, the new Single Step macro action lets you enter single-step mode at any point in your macro, so that you can see how your macro performs one action at a time.

Temporary variables: Three new macro actions – Set Temp Var, Remove Temp Var, and Remove All Temp Var – let you make and use temporary variables in your macros. You can use these in conditional expressions to control running macros, or to pass data to and from reports or forms, or for any other purpose that needs a temporary storage place for a value.

MS access is a great database tool and has great built-in functions to help you create a database, explore more.
About Author: It is the leading website is about learning to build an Access database using the most effective techniques.In this Articles it talks about Microsoft access.To know more visit at https://www.accessdatabasetutorial.com/

mobilemax06-20
US