Arthur Fuller
fuller.artful at gmail.com
Tue Jan 13 07:37:15 CST 2009
Thanks, Chester. While we're on the subject, I vaguely recall that there is something special one must do in order to install a custom toolbar on a client's machine. Is that correct, or is it simply part of the MDB FE and automatically included? Another question, regarding your mention of Tools/References. Suppose I'm developing in A2K7 and the client will run it in A2K3. Will the specific reference to the Office library version break it? If so, is there a way to virtualize this reference, or does the developer simply tell the client how to get to Tools/References and delete the MISSING reference and then recompile, or...? One final question. The documentation I read this morning on MSDN refers to both command bars and toolbars. Is there a difference, and if so, what is it? Thanks, Arthur On Tue, Jan 13, 2009 at 8:22 AM, Kaup, Chester < Chester_Kaup at kindermorgan.com> wrote: > Try this > > For Each cmdBar In CommandBars > If cmdBar.Visible Then > sTemp = cmdBar.Name > DoCmd.ShowToolbar sTemp, acToolbarNo > End If > Next > DoCmd.showtoolbar "My Menu", acToolbarYes > > Make sure you have the Microsoft Office 10.0 object library declared as a > reference in Tools/References. >