Introduction to macros - Microsoft Support
This article explains what macros are in Access databases and how they can save you time by automating tasks that you perform often. It explores the fundamentals behind creating and using macros and also touches on improvements to macros in Access.
Introduction to Access programming - Microsoft Support
In Access, programming is the process of adding functionality to your database by using Access macros or Visual Basic for Applications (VBA) code. For example, suppose that you have created a form and a report, and you want to add a command button …
Create a user interface (UI) macro - Microsoft Support
You use (UI) macros to automate a series of actions, such as opening another object, applying a filter, starting an export operation, and many other tasks. This article introduces you to the newly-redesigned macro builder, and shows you the basic tasks involved in creating a UI macro.
Create a data macro - Microsoft Support
Data macros in Access enable you to add logic to events that occur in tables, such as adding, updating, or deleting data. They are similar to "triggers" in Microsoft SQL Server. This article shows you how to create and debug data macros.
Create a macro that runs when you open a database
If you want to perform a particular set of actions every time that an Access database starts, you can create an AutoExec macro. For example, you might want to automatically maximize the application window, lock the Navigation Pane, and then open a particular report.
Create or run a macro - Microsoft Support
Run a macro. Make a macro available in all documents. Add a macro button to the ribbon. Write a macro from scratch in Visual Basic. Record or create a macro and run it with a button or keyboard shortcut.
Create custom menus and shortcut menus by using macros
You can use Access macros to create custom shortcut menus that appear when you right-click forms, reports, or individual controls. You can also create custom menus that appear on the Ribbon for specific forms or reports.
Run an Access macro by using a keyboard shortcut
You can assign an action or set of actions to a specific key or keyboard shortcut by creating an AutoKeys macro group with submacros for each keyboard shortcut you want to create. When you press the key or keyboard shortcut, Microsoft Office Access performs the action.
If...Then...Else Macro Block - Microsoft Support
You can use the If macro block in Access desktop databases and Access web apps to conditionally execute a group of macro actions, depending on the value of an expression. If expression Then Insert macro actions here ...
RunMacro Macro Action - Microsoft Support
You can use the RunMacro macro action in Access databases to run a macro. The macro can be in a macro group. Use this action: To run a macro from within another macro. To run a macro based on a certain condition. To attach a macro to a custom menu or ribbon command.
Enable or disable macros in Microsoft 365 files
Block suspicious macros in Office on Windows 10 S. How malware can infect your PC. Improve security, evaluate and mitigate the risks of running macros, and see how to enable or disable macros for Microsoft 365.