Solved

Quick Access Toolbar --> Different Image or verbiage

Posted on 2013-05-29
6
448 Views
Last Modified: 2013-06-06
Version --> Access 2010

In the Quick Access Toolbar can I change the icon and change it to verbiage?

In Access 2003 I could make a button that said --> "My Button" on a toolbar.  Is that asking for something that can't be done?

thanks
LJG
0
Comment
Question by:LJG
  • 3
  • 3
6 Comments
 
LVL 75
ID: 39205258
Note that Microsoft does not supply any tool to create 'custom' Ribbons in A2010 (or 07/13).  

For everything Ribbons ... this is the de-facto standard tool ( and a LOAD of great info):

http://www.ribboncreator2010.de

mx
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 500 total points
ID: 39205353
Note that you can ... customize the QAT itself, but I don't think you can change the Icon or Verbiage. It may be possible to do so via vba code by somehow tapping into the Ribbon internals, but I have not seen this done. Someone may know how.

Look around on Gunter's site ...

mx
0
 
LVL 2

Author Comment

by:LJG
ID: 39205838
I found how to change the Icon -

File / Options / Quick Access Toolbar
on the Right window click the QAT icon you want to change.
Under the window Click Modify
Pick the Icon you want (You can also change the name that displays when you mouse over)

So still have the question --> Can I have a button that reads "My Button" when your not mousing over?
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 75
ID: 39205859
Interesting ... my Modify button is grayed out all the time ...
0
 
LVL 2

Assisted Solution

by:LJG
LJG earned 0 total points
ID: 39209156
DatabaseMX  -  Try a command that is always available.  My show and solves part of my problem.

OK - I can put macros on the QAT,  
      >>File / Options / Quick Access Toolbar / Choose Commands From -->Macro

I can associate an MS Icon with any command on the QAT (See my comment above)

I can't find a way to put verbiage on the QAT.   But - If you want to research it I would recommend you look at the below two sites.

This is about Excel - but might be able to be used with Access --> Access Customizations.exportedUI  (see next link)
      http://msdn.microsoft.com/en-us/library/office/ee704589(v=office.14).aspx

Export your QAT to a XLM file (similar to XML file) ---> Access Customizations.exportedUI
http://gregmaxey.mvps.org/word_tip_pages/modify_qat_button_image_text.html

If you figure it out - come back and let us know.

Thanks
LJG
0
 
LVL 2

Author Closing Comment

by:LJG
ID: 39224938
It adds to the conversation
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now