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,

Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    19th March 2019 - 12:49 AM