You are here:   FAQ Access 2010

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>


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.

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>
 

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

5.

Last Updates:

04.01.2016
Add new Link. ...


22.09.2015
New - IDBE RibbonCreator 2016 32 Bit and 64 Bit (Version 1.1001) ...

26.06.2015
Update Downloads for "Trusted Locations" - Versions ...

15.10.2014
Add new Link. ...

 

Last update:
January 22, 2017, 17:44