[RESOLVED] CommandBar problem

I am trying to create a commandbar, but unfortunately I am getting the following error: User defined type not defined. And yes, I have set a reference to Microsoft 9.0 Object Library in the VBE. That was the first thing I checked....

The error occurs at the first line, where I try to declare the command bar:

VB Code:

Dim cbrMenuBar As CommandBar
Set cbrMenuBar = CommandBars.Add("MyBar", msoBarTop, True, True)
cbrMenuBar.Visible = True

Thanks all

?? strange. did you try removing the library? then adding it back in?
was CommandBar an available "choice" in the intellisense dropdown?

"Microsoft 9.0 Object Library"? Which program are you trying to add it to?

Usually you add a reference to "Microsoft Excel xx.0 Object Library"

i kept having this problem , try adding office. before the commandbar?

worked for me, the same with outlook, i had to write outlook.application, just wouldnt work with application on its own

jamie

Ok, thanks for the feedback guys. No, commandbar was not a choice in the intellisense dropdown. This code is part of an export routine in Access - what I am trying to do is output a word document. My database contains test scripts that our company uses to test our products, what I am trying to do is output these test scripts to a word document as autotext entries, and then attach each one to a button on a commandbar.

ok.. if you do not get CommandBar as an Intellisense choice then u do not have the correct refrence...

Try adding ref to Word Object...

Try typing Office. is office a "choice"?

If your writting this with Word then it will be accessible from...

VB Code:

Application.CommandBars

After doing a bit more investigation I have found that the code I originally posted works fine if it is in a word document, so my problem is with Access. Is there any way to write out a word document from access and create the toolbar at the same time? If not I guess I will just have to write this code in word and have it get the data from access, I was really hoping to have it the other way round... in any case thanks for your help guys :)

Did you add a reference to Word and Office in Access' VBA IDE?

Did you add a reference to Word and Office in Access' VBA IDE?

Ok, thanks, thats the problem! I only had a reference to word - I did not have a reference to the Office objects library.