Solved

Access 2010, backstage button problem

Posted on 2011-03-03
2
804 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
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…

867 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

19 Experts available now in Live!

Get 1:1 Help Now