Solved

Access 2010, backstage button problem

Posted on 2011-03-03
2
800 Views
Last Modified: 2013-11-27
In table Usysribbons I have the following xml:

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
  <ribbon startFromScratch="false">
    <!-- Ribbon XML -->
  </ribbon>
  <backstage>
    <button id="btnBackstage1" label="Label Backstage Button" imageMso="HappyFace" onAction="OnActionButton"/>
  </backstage>
</customUI>

In Module1 I have following code:

Sub OnActionButton(control As IRibbonControl)
 
    Select Case control.Id
    Case Else
            MsgBox "Button """ & control.Id & """ clicked", vbInformation
    End Select
End Sub

When I start my access app the button appears correctly but gives an error when clicked. The error says something like: "Access can't run macro or callbackfunction OnActionButton" . Se picture for details.
Appreciate any tips or hint on what I'm missing.
2011-03-03-085536.jpg
0
Comment
Question by:hallpett
2 Comments
 

Accepted Solution

by:
hallpett earned 0 total points
ID: 35026810
Problem solved! Reference to "Microsoft Office 14.0 Object Library" was missing.
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Suggested Solutions

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…
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 …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

706 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

18 Experts available now in Live!

Get 1:1 Help Now