Solved

Quick Access Toolbar --> Different Image or verbiage

Posted on 2013-05-29
6
464 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 - 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
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

820 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