Solved

Quick Access Toolbar --> Different Image or verbiage

Posted on 2013-05-29
6
474 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 - Microsoft MVP, Access and Data Platform) 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
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
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

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

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

Suggested Solutions

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

751 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