How to Create a Command to Close All Open Objects in Microsoft Access
Question details
The user wants to find or create a command to close all open document tabs or objects simultaneously.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Managing multiple open tables, queries, or forms in a database and needing to close them all at once.
- Observed behavior
- Microsoft Access lacks an obvious built-in keyboard shortcut or default Quick Access Toolbar button for the Close All command.
Ensure you have saved any critical changes to your open database objects, as executing a Close All command will prompt you to save or discard unsaved modifications.
Create a Macro and Add it to the Quick Access Toolbar
Build a custom macro using the RunMenuCommand action to replicate the Close All functionality, then pin it to your interface.
While Microsoft Access does not feature a default keyboard shortcut for 'Close All', you can easily build a simple macro and pin it to your Quick Access Toolbar for one-click access.
Open your database, navigate to the 'Create' tab on the ribbon, and click 'Macro' in the Macros & Code group.
In the macro designer, click the drop-down arrow to add a new action and select 'RunMenuCommand' from the list.
Set the Command argument to 'CloseAll'. Note: If you are using the German version of Access, you will select 'AusführenMenübefehl' and set the command to 'SchließenAlle'.
Click the Save icon, name the macro something recognizable like 'CloseAllObjects', and close the macro designer.
Click the down arrow at the end of your Quick Access Toolbar (top-left of the window) and select 'More Commands'. Under 'Choose commands from', select 'Macros', locate your new macro, and click 'Add' to pin it to the toolbar.

Looking for a Lightweight Office Suite?
While WPS Office does not include a direct database replacement for Microsoft Access, it is an excellent, free alternative to Microsoft Word, Excel, and PowerPoint. Enjoy a familiar tabbed interface where managing and closing multiple documents simultaneously is a built-in feature.

Frequently Asked Questions
Is there a default keyboard shortcut to close all objects in Access?
No, Microsoft Access does not provide a built-in keyboard shortcut equivalent to the Close All command found in other Office applications. Creating a macro and adding it to the Quick Access Toolbar is the best workaround.
Can I use this macro in other Microsoft Access databases?
By default, the macro you create is only available in the active database. To use it globally across multiple databases, you must save and distribute the macro as an Access Add-in.
What is the macro command name in the German version of Access?
If you are using the German version of Microsoft Access, you should select the 'AusführenMenübefehl' action and choose 'SchließenAlle' as the specific command.




