[AccessD] Office Link in a customed Menu Bar

philippe pons phpons at gmail.com
Wed Jul 2 03:52:43 CDT 2008


Hi all,

I need your help!

I have an A2003 application that is being used under A2007.

This application exposes a customed menu bar, with a command button that
triggers an Office link to Excel or Word.
It allows the user to export reports to XL or Word.

What happen under A2007 is that the custom menu bar is there, but not the
Office Link button.
However, the following VBA command:
?Application.CommandBars("myCustomedMenuBar").Controls(9).caption
returns &Liaisons Office (i.e Office Link), showing that the control is
still there within the command bar.
Both properties Enable and Visible of this control are true.
But the control will not display!!

Do you know how I could give a new birth to this control?

Or is it possible to recreate such a command by code?

What I could you do is create a "normal" button, and give its onAction
property the name of a function that will do
the Office Link. But what is the VBA command that could do that?

Thank's in advance for any help,

Philippe



More information about the AccessD mailing list