[AccessD] Toolbar Control

Kaup, Chester Chester_Kaup at kindermorgan.com
Tue Jan 13 07:22:20 CST 2009


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.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Tuesday, January 13, 2009 6:44 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Toolbar Control

What's the VBA code to hide all the built-in toolbars when your app opens? I
know how to add my own custom toolbar but not how to hide the existing ones.

TIA,
Arthur
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list