[RESOLVED] CommandBar problem

[Santos7772005]

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:

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

Thanks all

[Static]

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

[RobDog888]

"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"

[jamielawjen]

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

[Santos7772005]

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.

[Static]

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"?

[RobDog888]

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

Application.CommandBars

[Santos7772005]

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

[RobDog888]

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

[Santos7772005]

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.