How To Disable Or Hide the A2007 Quick Access Toolbar

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wayne - 28 Feb 2008 09:10 GMT

I've searched this forum and trawled the wider web and can't find any
information on how to hide or disable the A2007 Quick Access Toolbar.
The toolbar is not something that one wants available to the user in a
custom application.

Can it be disabled or hidden and if so, how?

Reply to this Message

lyle - 28 Feb 2008 17:22 GMT

> I've searched this forum and trawled the wider web and can't find any
> information on how to hide or disable the A2007 Quick Access Toolbar.
> The toolbar is not something that one wants available to the user in a
> custom application.
>
> Can it be disabled or hidden and if so, how?

This hides both the ribbon and the QAT in Northwinds 2007.accdb.

DoCmd.ShowToolbar "Ribbon", acToolbarNo

But then what? I'm guessing one will want a custom ribbon or toolbar.

Reply to this Message

Wayne - 29 Feb 2008 06:19 GMT

> This hides both the ribbon and the QAT in Northwinds 2007.accdb.
>
> DoCmd.ShowToolbar "Ribbon", acToolbarNo
>
> But then what? I'm guessing one will want a custom ribbon or toolbar.

After more web trawling, I've found that it seems like the only way to
disable the QAT is by using a custom ribbon and coding the ribbon to
disable the toolbar. I have no great desire to learn XML at this
point in time for the sole purpose of building custom ribbons, and
have found a tool to do just that here: http://www.ribboncreator.de/en/
The site also has tutorials on how to code a ribbon from scratch.

I've downloaded and tested the shareware version that is limited to a
max of 10 buttons and it works well. The asking price of $23.50 US
seems reasonable. I'd be interested to hear if anybody knows of other
similar tools.

Reply to this Message