Hide the Quick Access Toolbar

Question

Any way to hide the Quick Access Toolbar? I dodn't use it at all 'cause any commands I use I've placed in custom ribbon items. I did find the following on the internet but the Ribbon gets hidden also and I don't want that:

DoCmd.ShowToolbar "Ribbon", acToolbarNo

James

Answer 1

As far as I can tell, the ribbon and QAT are connected inextricably.

Are you sure Hans?  I could have sworn that the Access Team had said that they introduced programmatical items for the Ribbon and QAT into Access 2010.  I haven't gone there yet but I may try it on the way home tonight on the bus.  I know you couldn't in Access 2007 but I'm wondering if there isn't a way in Access 2010.

Answer 2

As far as I can tell, the ribbon and QAT are connected inextricably. You'd probably have to create your own ribbon from scratch using RibbonXML and include a line

<ribbon startFromScratch="true">

to hide both the built-in ribbon and QAT.

Hi HansV

My name is Daniel, I hope this reaches you while all is well in your life.

I'm working with access 2016, I am somewhat literate in Access and believe that I may be able to create a custom ribbon for my database, so because I am not sure if this question has been resolved during the past six years and posted anywhere, so I resort to asking you based on your post from 2011!

My question is if you actually managed to "hide" the QAT by using the method you described. In my office it would be desirable to limit the possibilities of employees "looking" around and "unintentionally"changing something as a result.

I thought of asking before attempting to create my own custom ribbon.

I'd appreciate any help on this issue.

Thanks. 

Daniel N

Answer 3

I cannot find anything in the Object Browser about toggling the ribbon and/or QAT in Access 2010.

Answer 4

That's what I thought.

There's nothing in it so it's not very noticable.

Thanks,

James

Answer 5

As far as I can tell, the ribbon and QAT are connected inextricably. You'd probably have to create your own ribbon from scratch using RibbonXML and include a line

<ribbon startFromScratch="true">

to hide both the built-in ribbon and QAT.