Solved

Access 2007 Ribbon Wont Display

Posted on 2008-10-28
2
534 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
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…
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 …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

744 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now