[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 288
  • Last Modified:

Problem with Command Bars

I have an app in which I create and use custom command bars (shortcut menus).  It works fine.

I created a new db and imported the entire app into it, for an unrelated reason.  Now, when I run the code (jpg attached), I get an error: Compile Error: User-defined type not defined.

Can anyone help?

Thanks in advance.

  Undefined type error
0
CRB1609
Asked:
CRB1609
  • 3
  • 2
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
In the VBA editor >> Tools>>References ... Look for any that are listed as:

**Missing <SomeReferenceName>

Resolve the missing Reference ...

mx
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Possibly a Missing Reference to the Office Object Library ...

mx
Capture1.gif
0
 
CRB1609Author Commented:
The References are identical:

Visual Basic For Applications
Microsoft Access 14.0 Object Library
Microsoft Office 14.0 Access database engine Object Library
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Jeffrey CoachmanCommented:
Are you running the original and the "Copy" on separate machines or the same machine?
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Can you post the code above code  so we can try it.  Is the error on the blue line of code?

If so ... that error message is almost *always* because of a Reference issue of some kind ...

mx
0
 
CRB1609Author Commented:
Very sorry, everyone.  I did not have the Microsoft Office 14.0 Library checked on.  Duh!  I just couldn't see for looking.

Thanks to all for the help.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now