upgrade access2003: user-defined type not defined

[leahf via AccessMonster.com]

I am upgrading from Access 2002 to Access 2003 and am getting the above error
while compiling.

The error falls on:


myMenuBar As CommandBar


I can't figure out why. I searched for CommandBar and haven't found it
anywhere suspicious.

Can anyone help?

Leah

 

[leahf via AccessMonster.com]

I just realized that the problem is that CommandBar is not defined in
Access2003.

Any suggestions what I can do?

Leah

 

[Douglas J. Steele]

CommandBar comes from the Office library, not the Access one.

Go into the VB Editor, select Tools | References from the menu, scroll
through the list of available references until you find the one for
Microsoft Office 11.0 Object Library, select it, then close the dialog.

 

[Douglas J. Steele]

You're sure it's a reference to Office 11? I ask because a reference to
Office 11 isn't set by default: what's set by default is a reference to
Access 11.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hi,

Thank you but I just checked and the Micrososft Office 11.0 Object Library
is
already selected. (I was so sure that was it because I just had Office
2003
installed).

Is there something else that I can try?

Thanks.
Leah

CommandBar comes from the Office library, not the Access one.

Go into the VB Editor, select Tools | References from the menu, scroll
through the list of available references until you find the one for
Microsoft Office 11.0 Object Library, select it, then close the dialog.

I just realized that the problem is that CommandBar is not defined in
Access2003.

[quoted text clipped - 17 lines]

Leah

 

[manolito]

lalala