Access 2010, backstage button problem

Posted on 2011-03-03
Medium Priority
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 -->
    <button id="btnBackstage1" label="Label Backstage Button" imageMso="HappyFace" onAction="OnActionButton"/>

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.
Question by:hallpett
1 Comment

Accepted Solution

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

Featured Post

7 new features that'll make your work life better

It’s our mission to create a product that solves the huge challenges you face at work every day. In case you missed it, here are 7 delightful things we've added recently to monday to make it even more awesome.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
Audit trails are very important in any system to hold people responsible for certain transactions and hold them to take ownership of their actions. This article is dedicated to all novice "Microsoft Access" developers.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

607 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