HOW TO HIDE THE RIBBON WHEN LAUNCHING MICROSOFT ACCESS DATABASE ?

1
HOW TO HIDE THE RIBBON WHEN LAUNCHING MICROSOFT
ACCESS DATABASE ?
2
Hide the Ribbon When Launching Microsoft access
database Having Ribbons in your Microsoft
access database application helps a lot when you
need to use all the tabs that are present on the
ribbon. However, there are times that you need to
prevent the tabs on the ribbon from displaying
when launching the application. MS Access, by
default, does not provide an option for hiding
the ribbon. Because of that,you have to opt for
external approaches. One way is to create and
apply a customized ribbon that can hide all the
built-in tabs. Before you begin, make sure
system tables are displayed in the Navigation
Pane. To do this, change a setting in the
Navigation Options dialog box so you can view
the USysRibbons table once it is created.
3
Follow these steps Right-click the Navigation
Bar at the top of the Navigation Pane, and then
click Navigation Options.
4
You should be able to see the Microsoft access
database system tables in the Navigation
Pane. Create the USysRibbons system table The
procedure below explains how to create the
USysRibbons system table which you will use later
to store your Ribbon customization XML. 1. On the
Create tab, click Table Design.
5
2. Add the following fields to the table. Make
sure you type the field names correctly. FIELD
NAMETYPEFIELD SIZE1.       ID1.      
AutoNumber1.       Long Integer1.      
RibbonName1.       Short Text1.       2551.      
RibbonXml1.       Long Text1. 3. If you want, you
may include more fields to this table.4. Select
the ID field and click Primary Key thats on the
Design tab, in the Tools group.
5. Press CTRLS and name the new table as
USysRibbons. Click OK to save the changes.
6
Add Ribbon customization XML to the USysRibbons
table This is how to create the XML with this
configuration 1. Right-click the USysRibbons
table in the Navigation Pane then click Open to
display the table in Datasheet view. 2. Copy the
following data and paste it into the
table. IDRibbonNameRibbonXML(AutoNumber)Custom
TabltcustomUIxmlnshttp//schemas.microsoft.com/of
fice/2006/01/customuigt ltribbon
startFromScratchfalsegt lttabsgt lttab
idMsoTabCreate visiblefalse /gt lttab
iddbCustomTab labelA Custom Tab
visibletruegt ltgroup iddbCustomGroup
labelA Custom Groupgt ltcontrol idMsoPaste
labelBuilt-in Paste enabledtrue/gt lt/groupgt lt
/tabgt lt/tabsgt lt/ribbongt lt/customUIgt 3. Close the
USysRibbons table.4. Close the database and open
in again.
7
Apply the custom Ribbon Since the custom Ribbon
XML has been added to the table, its time to
apply the custom Ribbon. If you want to apply the
custom Ribbon to the entire database, do the
following 1. Launch Access and open the
database. 2. Click File then Options to open
Access Options dialogue box. 3. Click Current
Database and locate Ribbon and Toolbar
Options. 4. Select the Ribbon Name list then
click the Ribbon that you want in this case,
Custom Tab. 5. Click OK.
8
If you choose to apply the custom Ribbon to a
specific form or report, here are the
steps Right-click the form or report that you
want to apply the custom Ribbon to and click
Design View. Press F4 to display the property
sheet if its not already shown. Under Selection
type, make sure that the object type (Form or
Report) is selected. On the Other tab of the
property sheet, click the Ribbon Name list, then
click the Ribbon that you want to be displayed
when opening the form or report in this case,
Custom Tab. Press CTRLS to save. Close the form
or report. Reopen it. Now, the Ribbon that you
selected is displayed.
9
Contact us
Ben Beitler
ben_at_accessdatabasetutorial.com
(44) 7881
502400
United Kingdom
London
https//www.accessdatabasetutorial.com/