quick access tool bar and the ribbon

K

Karen

Hi,

I am using Access 2007 and would like to create a customized toolbar. I have
added items to the quick access toolbar and have used code found in the
discussion group to effectively hide the ribbon. However, when I hide the
ribbon the quick access toolbar is also hidden.

Any suggestions on how to keep the ribbon hidden but allow the user access
to items on the quick access toolbar (such as print, export to word)?

Thanks.
 
M

Maurice

Hi Karen,

I assume you have the Usysribbons table with the expected xml inside.
When you start the ribbon from scratch you have to rebuild your QAT as well
from scratch. See example below; this will hide the ribbon and show the QAT
with the predefined buttons. So find out what the predefined button is for
Export to Word and place it in there...


<?xml version="1.0" encoding="utf-8"?>
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon startFromScratch="true">
<qat>
<sharedControls>
<button idMso="FileSave"/>
<control idMso="Undo"/>
<control idMso="Redo"/>
</sharedControls>
</qat>
</ribbon>
</customUI>

hth
 
K

Karen

Thanks. Using your example and finding out the names for the predefined
buttons got it to work.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top