<

How to Add a "Save As" icon to the Quick Access Toolbar

Posted on
7,579 Points
379 Views
2 Endorsements
Last Modified:
Published
Experience Level: Beginner
2:43
crystal (strive4peace) - Microsoft MVP, Access
Love empowering people by teaching and helping them develop applications.
How can you see what you are working on when you want to see it while you to save a copy?

Add a "Save As" icon to the Quick Access Toolbar, or QAT.

That way, when you save a copy of a query, form, report, or other object you are modifying, you can still see what you are doing and can give your object a better name.

While Access is used to demonstrate,  you can do this in other Office products like Word, Excel, and PowerPoint too.

have an awesome day,
crystal

Video Steps

1. click on down arrow at end of QAT to Customize it

2. Choose "More Commands..." from the drop-down menu

3. choose to show 'All Commands'

4. click on the last command in the list of QAT commands on the right


   or whatever command you want to add the command below

5. double-click <Separator> in the left list to add it to the right list below what is selected

6. in the left list, doube-clicm Save As to addit below what is selected (now the separator)

7. click OK to close the Customize the Quick Access Toolbar dialog box

8. Enjoy faster saving!

2
0 Comments
When running slow stored procedures from Access it may be useful to have the application do something else rather than just show the hourglass.   In this example a form flashes a message while the stored procedure executes, and then closes itself on…
I wrote this article because I was unable to find an article on this here on EE.  Read on for step-by-step instructions on how to create a custom command ribbon in your office applications that not only make them look more professional but also prot…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month