X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Remove The Views Group From The Home Tab On Default Ribbon, Access 2016    
post Feb 1 2018, 05:10 PM

Posts: 14
Joined: 1-February 18

Greetings all and thanks in advance for your help. How would I modify this xml to remove just the views group from the home tab of the ribbon. I want to remove the ability to switch an applications presented query to design mode. Thanks

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui"
<ribbon startFromScratch="true">
<tab idMso="TabHomeAccess" label="Home" visible="true" />
<tab idMso="TabCreate" label="Create" visible="false" />
<tab idMso="TabExternalData" label="External Data" visible="false" />
<tab idMso="TabDatabaseTools" label="Database Tools" visible="false" />
<tab id="dbCustomTab" label="Service Meeting Program" visible="false">

<tab idMso="TabInfo" visible="true"/>
<button idMso="FileSave" visible="false"/>
<button idMso="SaveObjectAs" visible="false"/>
<button idMso="FileSaveAsCurrentFileFormat" visible="false"/>
<button idMso="FileOpen" visible="false"/>
<button idMso="FileCloseDatabase" visible="false"/>
<tab idMso="TabRecent" visible="false"/>
<tab idMso="TabNew" visible="false"/>
<tab idMso="TabPrint" visible="false"/>
<tab idMso="TabShare" visible="false"/>
<tab idMso="TabHelp" visible="false"/>
<button idMso="ApplicationOptionsDialog" visible="false"/>
<button idMso="FileExit" visible="false"/>
Go to the top of the page
post Feb 1 2018, 05:27 PM

Posts: 18,324
Joined: 29-March 05
From: Wisconsin


> I want to remove the ability to switch an applications presented query to design mode.

You could create a simple form or report to display the query's contents and distribute a compiled .accde file. I never give my users direct access to a query. It's too hard to control what they might do with the data.

Hope this helps,


(;,;) Li'l Cthulu says: Please talk about what you're trying to do, as well as how you're doing it.
Changing your real table name to "Table1" and your real form name to "Form1" in your posts makes it more difficult to understand what's going on, not easier.
Guidelines for Posting Questions
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    25th September 2018 - 06:00 AM