Solved

MS Access hide dropdown beside quick access toolbar

Posted on 2013-11-25
2
474 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
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

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

Suggested Solutions

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
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…

910 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

19 Experts available now in Live!

Get 1:1 Help Now