Access Ribbon

[JKwan]

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

[JKwan]

Solved it, the missing reference is MS Office 14.