Others

How to Create a Command to Close All Open Objects in Microsoft Access

Nimra MalikNimra Malik Oct 29, 2026 868 views

Question details

The user wants to find or create a command to close all open document tabs or objects simultaneously.

How to Create a Command to Close All Open Objects in Access
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.
Before you start

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.

Solution 1Recommended

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.

1
Create a new Macro

Open your database, navigate to the 'Create' tab on the ribbon, and click 'Macro' in the Macros & Code group.

2
Add the RunMenuCommand action

In the macro designer, click the drop-down arrow to add a new action and select 'RunMenuCommand' from the list.

3
Select the CloseAll command

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'.

4
Save the Macro

Click the Save icon, name the macro something recognizable like 'CloseAllObjects', and close the macro designer.

5
Add to Quick Access Toolbar

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.

Create a Macro and Add it to the Quick Access Toolbar
Application-Wide Availability: By default, this macro will only work in the active database. To make the command available across all your Access databases, you must package and install it as an Access Add-in.
Free Microsoft Office alternative

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.

Fully compatible with Microsoft Office formats (.docx, .xlsx, .pptx).Built-in intuitive tabbed interface allows you to close all documents easily without writing macros.Lightweight design ensures fast startup and smooth operation on any device.Free to use with comprehensive editing, formatting, and sharing tools.
microsoft office alternative - wps office

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.