[AccessD] Disable Customizing of Menus in Code (Access 97)

Jeffrey:

Yes, that works, but I need to do it programmatically.  Not using the
interface, but through VB so I can turn it on and off depending on the
user's name.  Or the security group they belong to.  I have the toolbars and
menus to load the ones I want for the users or programmers, but I have to
turn off the customizing through the program (vb) or they can very easily
defeat my menus be adding their own stuff to the bars.  If I try using the
interface, it's local only and will not apply to other machines where the
app is loaded.

Greg

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
jeffrey.demulling at usbank.com
Sent: Friday, July 30, 2004 3:25 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Disable Customizing of Menus in Code (Access 97)





You need to go into the toolbar using View, Toolbars, Customize.  Select
the toolbar in question and then click the properties button.  From here
you can deselect the allow customizing option.  This should solve your
problem.


 

                      "Greg Smith"

                      <GregSmith at starband.net>         To:
accessd at databaseadvisors.com

                      Sent by:                         cc:

                      accessd-bounces at databasea        Subject:  [AccessD]
Disable Customizing of Menus in Code (Access 97)                    
                      dvisors.com

 

 

                      07/30/2004 03:16 PM

                      Please respond to "Access

                      Developers discussion and

                      problem solving"

 

 





I'm back.  Must be 'bad penny' Friday.

I now have the db window hidden (thanks again Charlotte!), and have the
correct menu bar showing for the users.  However, anyone can right mouse
click on the menubar, click customize, and either modify the existing one
or create a new menubar with all the options that I've gone to the trouble
of hiding.  There has to be a way to disable this function in Access.  The
shortcut menus don't affect the tool bar or menu bar menu selection from
the right mouse click.  Turning off shortcut menus on the form does not
keep the Customize menu selection from appearing when clicked in the
toolbar area.

Ideally that menu customizing function should be turned off through the
code so it can't be restarted by anyone using the program (except the
programmer, of course...).

Am I barking up the wrong tree?  Is this possible?  Or do I need some
completely different route to get where I want?

TIA!

Greg Smith
gregsmith at starband.net


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





----------------------------------------------------------------------------
--
Electronic Privacy Notice. This e-mail, and any attachments, contains
information that is, or may be, covered by the Electronic Communications
Privacy Act, 18 U.S.C. 2510-2521, and is also confidential and proprietary
in nature. If you are not the intended recipient, please be advised that you
are legally prohibited from retaining, using, copying, distributing, or
otherwise disclosing this information in any manner. Instead, please reply
to the sender that you have received this communication in error, and then
immediately delete it. Thank you in advance for your cooperation.
============================================================================
==

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