Solved

Access 2007 Ribbon Wont Display

Posted on 2008-10-28
2
544 Views
Last Modified: 2012-05-05
I am trying to develop a ribbon and whilst some success with various GUI tools my access DB and clean access DB's will not display a test Ribbon for some reason

As I say I have created a blank database with the following ribbon defined in USYSRIBBONS

Access 2007 SP1  - Vista 32 SP1

Havent got other machines to test as I am onsite today

Amended Database Options and selected this ribbon

When I load the database it does not display

I have been creating the Ribbons in Ribbon Customizer by claton hendricks

Please advise

As a side issue is there a better customiser - I saw a really good customiser for Word but not Access 2007

Thanks in advance

Paul


<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon startFromScratch="true">
<tabs> <tab idMso="TabHomeAccess" visible="false"/>
<tab id="dbCustomTab" label="wizardwaste" visible="true">
 
<group id="Skips" label="Skips">
 
<button id="MACTEST" label="Test Macro" onAction="MACTEST"/>
</group>
 
<group id="Skips" label="Skips">
 
<button id="" label="macro test" onAction=""/>
</group>
</tab>
</tabs>
</ribbon>
</customUI>

Open in new window

0
Comment
Question by:Wizard_IT
2 Comments
 
LVL 9

Accepted Solution

by:
borki earned 500 total points
ID: 22820683
Hi Paul

I think your Ribbon XML has two groups both named skips. Try to rename them, so they are unique. Also I am usure what the line
<tab idMso="TabHomeAccess" visible="false"/>
is for, maybe leave it out.

I use the excellent Ribbon Creater from Gunter Avenius, found at:

http://www.ribboncreator.de/en/index.php

The shareware version is restricted to two tabs, three groups and ten controls. Full version is US$23.50

I have modified your ribbon code in the Ribbon Creater (see code). It uses VBA code modules to handle the ribbon events...

HTH

Felix


<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" onLoad="OnRibbonLoad" loadImage="LoadImages">
<commands>
    <command idMso="Help" enabled="true"/>
    <command idMso="WindowClose" enabled="true"/>
    <command idMso="WindowRestore" enabled="true"/>
    <command idMso="WindowMinimize" enabled="true"/>
</commands>
  <ribbon startFromScratch="false">
    <tabs>
      <tab id="dbCustomTab" label="wizardwaste" getVisible ="GetVisible">
        <group id="grpSkips1" label="Skips1" getVisible ="GetVisible">
          <button id="btnMacro1" size="large" label="Macro 1" tag="RibbonName:=;inMenu:=;CustomPicture:=;CustomPicturePath:=" onAction="OnActionButton" getVisible="GetVisible" getEnabled="GetEnabled" />
        </group>
        <group id="grpSkips2" label="Skips2" getVisible ="GetVisible">
          <button id="btnMacro2" size="large" label="Macro 2" tag="RibbonName:=;inMenu:=;CustomPicture:=;CustomPicturePath:=" onAction="OnActionButton" getVisible="GetVisible" getEnabled="GetEnabled" />
        </group>
      </tab>
    </tabs>
  </ribbon>
</customUI>

Open in new window

0
 

Author Closing Comment

by:Wizard_IT
ID: 31510655
just closing call due to EE changes !!!
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question