You are here:   Home > FAQ > FAQ Access 2010

 
Only Access 2010 / 2013 - FAQ
FAQ (Access 2007/2010/2013)
 
1

 

 

In contradiction to the description available with the "Help Button", this Toggle Button can not be deactivated.
The following XML code will be executed without error message, the Toggle Button will remain active.

   <commands>
       <command idMso="MinimizeRibbon" enabled="false"/>
   </commands>


#​CMSimple hide#

2

Quick Access

For these  Checkbox there's no RibbonXML Callback available, furthermore there's no option (SetOption) that could be set by using VBA.

 

 

 

 

 

 

 

Use following RibbonXML to hide the MRU:

<backstage>
   <tabidMso ="TabRecent" visible="false"/>
</backstage>

or:


This setting is made to the registry and will be stored for the current user.

Use the following code to hide or display the recent databases at startup.

 

'Code into a new standard module:
  
Public Enum ShowQuickAccesDisplay
    show = 1
    hide = 0
End Enum
  
Public Sub SetBackstageQuickAccessDisplay(iShow As ShowQuickAccesDisplay)
  Dim objWSHShell As Object
  Set objWSHShell = CreateObject("WScript.Shell")
  objWSHShell.RegWrite "HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\File MRU\Quick Access Display", iShow, "REG_DWORD"
  'In Excel use :
  ' objWSHShell.RegWrite "HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\File MRU\Quick Access Display", iShow, "REG_DWORD"
  'In Word use:
  ' objWSHShell.RegWrite "HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Word\File MRU\Quick Access Display", iShow, "REG_DWORD"
  Set objWSHShell = Nothing
End Sub

 

Use:

   SetBackstageQuickAccessDisplay show 'Display

respectively:

   SetBackstageQuickAccessDisplay hide 'Hide 

Ensure the resetting of the original value on closing the database.

#​CMSimple hide#

3

Assume you have configured the help button to initiate a customize callback:

  <commands>
       <command idMso="Help" onAction="OnActionHelpButton"/>
  </commands>

 

While a click on the help button on the ribbon initiates the callback in a proper way, a click on the help button in the BackStage area opens the
Access help.

This is a bug in Access 2010 and the only option is to disable the Help button completely.

  <commands>
       <command idMso="Help" enabled="false"/>
  </commands>
 

#​CMSimple hide#

4


No, you cannot hide only the "File" Tab. 

The following Code hide the Ribbon (with File Tab and BackstageView Menu):

  DoCmd.ShowToolbar "Ribbon", acToolbarNo 

View Ribbon:

  DoCmd.ShowToolbar "Ribbon", acToolbarYes

#​CMSimple hide#

5

Last Updates:

18.03.2021
New Download added. ...

25.10.2018
Update Site "Trusted Locations" ...

22.10.2018
New Download added. ...

08.04.2018
IDBE RibbonCreator 2016 (x86 and x64) for Office 2013 and Office 2016 - new release. ...

 

Last update: