[AccessD] 'splain this thing to me - toolbars

John,

I guess you already know that you associate a
particular menu or toolbar with a form or report
by using the object's property sheet so that OnOpen
it will get the bar.

However, all of the bars are available in Commandbars,
which is how you access them programmatically.

The CommandBar itself stores it's binary information
in the registry under the following key:

HKEY_CURRENT_USER\Software\Microsoft\
Office\9.0\Access\Settings\CommandBars

Some of the information you are seeking can
be found on the StartUp menu, which is accessed
using Application.GetOption / SetOption.

Michael R. Mattys
Try MattysMapLib for MapPoint at
www.mattysconsulting.com



----- Original Message -----
From: "John Colby" <jcolby at colbyconsulting.com>
To: "AccessD" <AccessD at databaseadvisors.com>
Sent: Monday, October 20, 2003 2:10 PM
Subject: [AccessD] 'splain this thing to me - toolbars


> Something I've never understood - where is the information stored about
what
> tool bar should be open for what form?  It seems to be a form collection,
> i.e. each form can have different toolbars open.  Right click on the menu
> bar and you get a list of the available tool bars for that form.  Is this
> collection available programmatically?
>
> Next question, what determines whether (for example) the Form View tool
bar
> is available for a specific form?  IOW, on my switchboard, I can see and
> turn on and off the form view menu with the form design tools etc.  From
my
> data entry forms that isn't available.
>
> It's all very cornfusing to me.  I'd love to be able to add code to my
> framework to disable all toolbars (not of my own design) whenever a form
> controlled by the framework opens, even if they right click the menu bar
> only my authorized tool bars exist.
>
> John W. Colby
> www.colbyconsulting.com
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com