Consulting

Results 1 to 2 of 2

Thread: Access Ribbon

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Expert
    Joined
    Aug 2004
    Posts
    810
    Location

    Access Ribbon

    I am trying to create a Ribbon in Access 2007, not having fun. I created the USysRibbons table and put my XML code in. The Ribbon shows up and my icon is displayed. What I am having trouble is that the button will not function! I don't know why?? I tried to declare:
    Public ribbon as IRibbonUI
    but the module does not pick up IRibbonUI..... Is there a Reference that I need to add?? I don't think so..... Excel just picks it up.


    my XML
    <customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
      <ribbon startFromScratch="false">
        <tabs>
          <tab idMso="TabCreate" visible="false" />
          <tab id="dbCustomTab" label="Personal Safety" visible="true">
            <group id="dbCustomGroup2" label="Data Loader">
        <button id="RunMyMacro" imageMso="GroupOrgChartArrange" label="Data Loader" size="large" onAction="LoadData()"/> 
            </group>
          </tab>
        </tabs>
      </ribbon>
    </customUI>
    So, in my module I should have this:
    sub LoadData (control As IRibbonControl)
    once again, it does not know what "IRibbonControl" is

  2. #2
    VBAX Expert
    Joined
    Aug 2004
    Posts
    810
    Location
    Solved it, the missing reference is MS Office 14.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •