Solved

MS Access hide dropdown beside quick access toolbar

Posted on 2013-11-25
2
506 Views
Last Modified: 2013-12-05
I have reviewed several post on this subject, but still fail to achieve my goal.  In MS Access there is a drop down beside the quick access toolbar.  This drop down allows the user to customize the QAT.  I need to either disable that drop down OR disable the more controls option on that drop down.  I don't care which.  I just need to block users from being able to add the design buttons to the QAT which would allow them to access the back-end.  I have my switchboard opening as Modal, so I'm close to locking this down to end users.  I just have this last problem.

I do have a custom ribbon.  I have removed all from the QAT and have my ribbons working correctly.  I just don't understand how to make the QAT where the end user cannot customize, or control what they can customize.

Thanks in advance for all help.
AJ
0
Comment
Question by:annagarrison
[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
2 Comments
 
LVL 61

Accepted Solution

by:
mbizup earned 500 total points
ID: 39675456
Are you using start from scratch in your ribbon XML?

You can also try adding empty QAT tags to your ribbon xml:

<QAT>
</QAT>


If that doesn't help, can you post the ribbon XML ?
0
 

Author Comment

by:annagarrison
ID: 39675474
I had tried that, thanks.  Here is my code.

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
  <ribbon startFromScratch="true">
  <qat>
    <qat/>
<tabs>
      <tab idMso = "TabHomeAccess" visible = "true"/>
       <tab idMso="TabCreate" visible="false" />
       <tab idMso = "TabDatabaseTools" visible = "false" />
        <tab idMso = "TabExternalData" visible = "false" />
       </tab>
    </tabs>
   </ribbon>
   </customUI>
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

738 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