Solved

Access 2007 Ribbon Wont Display

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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Turn off MS Access Default=0 for Numerics 6 26
Access Open Report with SQL Parameter 11 30
Dcount help 2 16
Advice on Listbox or Listview usage 3 13
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

777 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