UtterAccess.com
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
> How To Hide Qat From Ms Access Ribbon, Access 2016    
 
   
marinko888
post May 7 2019, 12:23 PM
Post#1



Posts: 58
Joined: 9-April 19



Hi,

does anybody knows how can I hide Quick Access Toolbar from MS Access Ribbon? I suppose it is possible through XML but don't know how.

Attached File  QAT.PNG ( 564bytes )Number of downloads: 5


Thanks,
Go to the top of the page
 
theDBguy
post May 7 2019, 01:20 PM
Post#2


Access Wiki and Forums Moderator
Posts: 75,559
Joined: 19-June 07
From: SunnySandyEggo


Hi. I'm not sure if it can be hidden but check out here.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
isladogs
post May 7 2019, 01:32 PM
Post#3


UtterAccess VIP
Posts: 1,417
Joined: 4-June 18
From: Somerset, UK


Just to confirm what DBG indicated.
You can't hide the QAT unless you hide the entire ribbon.
If you want to hide/show the ribbon and QAT, use the following code in a standard module

CODE
Option Compare Database
Option Explicit

Public Function HideRibbon()
    'could run at startup using Autoexec
    'however this also hides the QAT which makes printing reports tricky
     DoCmd.ShowToolbar "Ribbon", acToolbarNo
   '  DoCmd.ShowToolbar "PrintReport", acToolbarYes
End Function

Public Function ShowRibbon()
    'use when opening a report to display print preview ribbon
     DoCmd.ShowToolbar "Ribbon", acToolbarYes
End Function

Public Function ToggleRibbonState()

'hide ribbon if visible & vice versa
    CommandBars.ExecuteMso "MinimizeRibbon"
End Function

Public Function IsRibbonMinimized() As Boolean
    'Result: 0=normal (maximized), -1=autohide (minimized)

    IsRibbonMinimized = (CommandBars("Ribbon").Controls(1).Height < 100)
   ' Debug.Print IsRibbonMinimized
End Function


You can see an example of this and other ways of managing the application interface at My Website

--------------------
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    20th June 2019 - 04:18 PM