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