Question How to hide/disable the 'Access Options' button in Access 2007

Surp

ICT professional
Local time
Today, 18:59
Joined
Dec 4, 2009
Messages
1
Is there a way to hide or disable the 'Access Options' button on the bottom of the Office Menu in Access 2007, please?
I use a custom ribbon (using the USysRibbons table) with following data:

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon startFromScratch="true">

<officeMenu>
<button idMso="FileOpenDatabase" visible="false"/>
<button idMso="FileNewDatabase" visible="false"/>
<splitButton idMso="FileSaveAsMenuAccess" visible="false" />
</officeMenu>

<tabs>

<tab id="Systeem" label="Systeem">
<group id="StatusSysteem" label="systeem">
<button id="Afsluiten" label="Afsluiten" size="large" imageMso="ProposeNewTime" supertip="Deze applicatie afsluiten." onAction="Ribbon.Afsluiten"/>
<button id="TaalInstellen" label="Gebruikerstaal" size="large" imageMso="AnimationAudio" supertip="De taal instellen." onAction="Ribbon.fSetTaal"/>
</group>
</tab>

<tab id="Klanten" label="Klanten">
<group id="StatusKlanten" label="klanten">
<button id="BeheerKlanten" label="Beheer" size="large" imageMso="AccessTableContacts" supertip="Toevoegen en/of wijzigen van klanten." onAction="Ribbon.fKlanten"/>
<button id="Verkoopscontracten" label="Contracten" size="large" imageMso="SignatureShow" supertip="Toevoegen en/of wijzigen van verkoopscontracten." onAction="Ribbon.fVerkoopscontracten"/>
<button id="Verkoopsofferten" label="Offerten" size="large" imageMso="FileViewDigitalSignatures" supertip="Toevoegen en/of wijzigen van verkoopsofferten." onAction="Ribbon.fVerkoopsofferten"/>
</group>
</tab>

<tab id="Producten" label="Producten">
<group id="StatusProducten" label="producten">
<button id="Omschrijving" label="Omschrijving aanpassen" size="large" imageMso="FunctionsTextInsertGallery" supertip="Wijzigen van de Nederlandstalige omschrijving en/of commerciële tekst van de producten." onAction="Ribbon.fProductOmschrijving"/>
</group>
</tab>

</tabs>
</ribbon>
</customUI>


Thanks in advance for any reply!
 
Have you tried disabling controls at Access Options->Current Database already?
 


hi
add a tag commands in the position indicated

success


Code:
[FONT=Courier New][COLOR=#0000ff]<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">[/COLOR][/FONT]
 
[FONT=Courier New][COLOR=red]<commands>[/COLOR][/FONT]
[FONT=Courier New][COLOR=red]<command idMso="ApplicationOptionsDialog" enabled = "false"/>[/COLOR][/FONT]
[FONT=Courier New][COLOR=red]<command idMso="FileExit" enabled = "false"/>[/COLOR][/FONT]
[FONT=Courier New][COLOR=red]<command idMso="Help" enabled = "false"/>[/COLOR][/FONT]
[FONT=Courier New][COLOR=red]</commands>[/COLOR][/FONT][COLOR=#0000ff]
[FONT=Courier New][/FONT] 
[/COLOR]
[FONT=Courier New][COLOR=#0000ff]<ribbon startFromScratch="true">[/COLOR][/FONT]
 
[FONT=Courier New][COLOR=#0000ff]<officeMenu>[/COLOR][/FONT]
[FONT=Courier New][COLOR=#0000ff]<button idMso="FileOpenDatabase" visible="false"/>[/COLOR][/FONT]
[FONT=Courier New][COLOR=#0000ff]<button idMso="FileNewDatabase" visible="false"/>[/COLOR][/FONT]
[FONT=Courier New][COLOR=#0000ff]<splitButton idMso="FileSaveAsMenuAccess" visible="false" />[/COLOR][/FONT]
[FONT=Courier New][COLOR=#0000ff]</officeMenu>[/COLOR][/FONT]
 
[FONT=Courier New][COLOR=#0000ff]<tabs>[/COLOR][/FONT]
 
[FONT=Courier New][COLOR=#0000ff]<tab id="Systeem" label="Systeem">[/COLOR][/FONT]
[FONT=Courier New][COLOR=#0000ff]<group id="StatusSysteem" label="systeem">[/COLOR][/FONT]
[FONT=Courier New][COLOR=#0000ff]<button id="Afsluiten" label="Afsluiten" size="large" imageMso="ProposeNewTime" supertip="Deze applicatie afsluiten." onAction="Ribbon.Afsluiten"/>[/COLOR][/FONT]
[FONT=Courier New][COLOR=#0000ff]<button id="TaalInstellen" label="Gebruikerstaal" size="large" imageMso="AnimationAudio" supertip="De taal instellen." onAction="Ribbon.fSetTaal"/>[/COLOR][/FONT]
[FONT=Courier New][COLOR=#0000ff]</group>[/COLOR][/FONT]
[FONT=Courier New][COLOR=#0000ff]</tab>[/COLOR][/FONT]
 
[FONT=Courier New][COLOR=#0000ff]<tab id="Klanten" label="Klanten">[/COLOR][/FONT]
[FONT=Courier New][COLOR=#0000ff]<group id="StatusKlanten" label="klanten">[/COLOR][/FONT]
[FONT=Courier New][COLOR=#0000ff]<button id="BeheerKlanten" label="Beheer" size="large" imageMso="AccessTableContacts" supertip="Toevoegen en/of wijzigen van klanten." onAction="Ribbon.fKlanten"/>[/COLOR][/FONT]
[FONT=Courier New][COLOR=#0000ff]<button id="Verkoopscontracten" label="Contracten" size="large" imageMso="SignatureShow" supertip="Toevoegen en/of wijzigen van verkoopscontracten." onAction="Ribbon.fVerkoopscontracten"/>[/COLOR][/FONT]
[FONT=Courier New][COLOR=#0000ff]<button id="Verkoopsofferten" label="Offerten" size="large" imageMso="FileViewDigitalSignatures" supertip="Toevoegen en/of wijzigen van verkoopsofferten." onAction="Ribbon.fVerkoopsofferten"/>[/COLOR][/FONT]
[FONT=Courier New][COLOR=#0000ff]</group>[/COLOR][/FONT]
[FONT=Courier New][COLOR=#0000ff]</tab>[/COLOR][/FONT]
 
[FONT=Courier New][COLOR=#0000ff]<tab id="Producten" label="Producten">[/COLOR][/FONT]
[FONT=Courier New][COLOR=#0000ff]<group id="StatusProducten" label="producten">[/COLOR][/FONT]
[FONT=Courier New][COLOR=#0000ff]<button id="Omschrijving" label="Omschrijving aanpassen" size="large" imageMso="FunctionsTextInsertGallery" supertip="Wijzigen van de Nederlandstalige omschrijving en/of commerciële tekst van de producten." onAction="Ribbon.fProductOmschrijving"/>[/COLOR][/FONT]
[FONT=Courier New][COLOR=#0000ff]</group>[/COLOR][/FONT]
[FONT=Courier New][COLOR=#0000ff]</tab>[/COLOR][/FONT]
 
[FONT=Courier New][COLOR=#0000ff]</tabs>[/COLOR][/FONT]
[FONT=Courier New][COLOR=#0000ff]</ribbon>[/COLOR][/FONT]
[FONT=Courier New][COLOR=#0000ff]</customUI>[/COLOR][/FONT]
 

Users who are viewing this thread

Back
Top Bottom