[AccessD] Where do they store the toolbar info

John,

<<Anyway, where the ^%*&^%(*^) is this stuff stored?>>

  Depends on version as to the actual table name, but it's a system table.
For example, for A97 it is MSysCmdBars.  For A2000 and up, I believe it's
MSysAccessObjects.

<<Does anyone have code to go find and get rid of these things throughout an
application (all forms).>>

  I don't have any.  I've always disabled all built-in toolbars and done my
own via code since A2 days.  Might want to check the MVP site or look at
some of the command bar collection stuff for code.

Jim Dettman
President,
Online Computer Services of WNY, Inc.
(315) 699-3443
jimdettman at earthlink.net

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John W. Colby
Sent: Thursday, January 01, 2004 8:18 PM
To: AccessD
Subject: [AccessD] Where do they store the toolbar info


I am going through a database I inherited trying to make the thing look and
act consistent.  One thing that I am running across is that some forms have
toolbars on such as "web design", "Form view" etc.  If you go to design view
/ properties / others, there is no toolbar in any of the toolbar properties
on this tab.

This is something that has always puzzled me and I never really ever figured
out.  This (what toolbars are being displayed) is "context sensitive", i.e.
if you click in the menu at the top of a form while in view mode (not design
view) and select a toolbar from the menu that appears, then close the form,
the form "retains" that toolbar as it opens next time.

That is simply nuts to me, who wants the form design toolbar viewable to the
user just because you used it yourself?


Does anyone have code to
go find and get rid of these things throughout an application (all forms).
I'm currently opening every form and if they have any of these menus, right
clicking on the top, unselecting the menu and saving (closing) the form
which gets rid of it... until the next time it is closed with one of these
menus selected.

Help!!!

John W. Colby
www.ColbyConsulting.com


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com