(RE: Access 2002 SP3)
There are many default toolbars that have the database window icon in
them. Different users will have various ones visible when my app
starts. When my app opens, I only want to display my custom toolbar in
my app and hide all others.
Here are some that some of my users have open...(my list keeps growing
here as I continue testing on different workstations:)
DoCmd.ShowToolbar "Database", acToolbarNo
DoCmd.ShowToolbar "Relationships", acToolbarNo
DoCmd.ShowToolbar "Table Design", acToolbarNo
DoCmd.ShowToolbar "Table Datasheet", acToolbarNo
DoCmd.ShowToolbar "Query Design", acToolbarNo
DoCmd.ShowToolbar "Query Datasheet", acToolbarNo
My list is growing as I said. So instead of listing them one by one,
is there a way via VBA to loop through *all* of the default toolbars,
check to see if that toolbar is visible and if it is , hide it?
Thanks.