[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 554
  • Last Modified:

Access 2007 Ribbon Wont Display

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
Wizard_IT
Asked:
Wizard_IT
1 Solution
 
borkiCommented:
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
 
Wizard_ITAuthor Commented:
just closing call due to EE changes !!!
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now