tailieunhanh - Automating Tasks with Macros
Collapsing, Expanding: by simply clicking the +/– button that appears to the left of the action name. Collapsing: hide some of this information. Expanding: Expand the action back into view. Grouping Macro Actions: subdivide a single macro in sections that help you concentrate on the portion of the macro that interests you. | Automating Tasks with Macros Macro Essentials A macro is a list of actions that happen when you run the macro. Creating a Macro: Choose Create Macros & Code Macro. Choose first action in the Add New Action list. Fill in the arguments for your action, using the text boxes that appear under it. Macro Essentials Running a Macro: there are four ways to run a macro. Run it directly by double-click its name in Navigation pane, Or, if the macro is open, choose Macro Tools | Design Tools Run. Can trigger it using a keystroke. Run it automatically when the database is first opened. Attach macro to a form. Editing a Macro Open macro in Design view Change action arguments. Reorder actions. Add a new action. Remove an action. Add comments. Collapsing, Expanding, and Grouping Macro Actions Collapsing, Expanding: by simply clicking the +/– button that appears to the left of the action name. Collapsing: hide some of this information. Expanding: Expand the action back into view. Grouping . | Automating Tasks with Macros Macro Essentials A macro is a list of actions that happen when you run the macro. Creating a Macro: Choose Create Macros & Code Macro. Choose first action in the Add New Action list. Fill in the arguments for your action, using the text boxes that appear under it. Macro Essentials Running a Macro: there are four ways to run a macro. Run it directly by double-click its name in Navigation pane, Or, if the macro is open, choose Macro Tools | Design Tools Run. Can trigger it using a keystroke. Run it automatically when the database is first opened. Attach macro to a form. Editing a Macro Open macro in Design view Change action arguments. Reorder actions. Add a new action. Remove an action. Add comments. Collapsing, Expanding, and Grouping Macro Actions Collapsing, Expanding: by simply clicking the +/– button that appears to the left of the action name. Collapsing: hide some of this information. Expanding: Expand the action back into view. Grouping Macro Actions: subdivide a single macro in sections that help you concentrate on the portion of the macro that interests you. Collapsing, Expanding, and Grouping Macro Actions To create a group: In the Add New Action list, choose Group. It’s the second entry. Enter a group name. Add actions to your group. Every group starts with the group name and ends with the text “End Group”. In between are the actions of the group. Collapsing, Expanding, and Grouping Macro Actions Example: Solving Macro Problems These steps to use single-step debugging: Open macro in Design view. Choose Macro Tools | Design ➝ Tools Single Step. Choose Macro Tools | Design ➝ Tools ➝ Run Click Step, Continue, or Stop All Macros, depending on what you want to do next. Managing Macros To manage macros, can use the sub macro feature. A sub macro is a small, named bundle of actions. The nifty of sub macros is can put many sub macros into a single macro object. Using sub macros, you can keep related functionality close .
đang nạp các trang xem trước
