access 2007 customize qat

[mikeba1]

Is there any way to stop users customizing the qat.
I do need the qat to provide certain functions, but would like to stop users from changing it.

thanks

 

[jambai]

See if this helps

http://msdn.microsoft.com/en-us/library/ee704589.aspx

 

[mikeba1]

Thanks

Have bitten the bullitt and created a qat in xml, this has solved most of my problems.

 

[jambai]

If you could share the xml and the procedure to use, it would be helpful.

 

[mikeba1]

you have to create a table called usysribbon

http://office.microsoft.com/en-us/access-help/customize-the-ribbon-HA010211415.aspx

then create an xml record
id- autonumber (key)
ribbonname - text
ribbonxml - memo


XML CODE (this is as far as I go with xml)

<customUI xmlns="

http://schemas.microsoft.com/office/2006/01/customui">

<ribbon startFromScratch="true">
<officeMenu>
<button idMso="FileOpenDatabase" visible="false" />
<button idMso="FileNewDatabase" visible="false" />
<button idMso="FileCloseDatabase" visible="false" />

</officeMenu>
<qat>
<documentControls>
<button idMso="FilterAdvancedByForm"/>
<button idMso="ApplyFilter"/>
<button idMso="FilterClearAllFilters"/>
<button idMso="Copy"/>
<button idMso="Paste"/>
<button idMso="PrintDialogAccess"/>
<button idMso="FindDialog"/>
<control idMso="Undo"/>
<control idMso="Redo"/>
<control idMso="ExportExcel"/>
</documentControls>
</qat>

</ribbon>
</customUI>

then tell access the name of the ribbon where it asks for it
in accessoptions currentdatabase ribbon and toolbar options

hope it helps