By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,164 Members | 1,001 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,164 IT Pros & Developers. It's quick & easy.

Right click in Toolbar

P: n/a
I recently sought help about how to prevent some users from accessing
certain toolbars.

Stuart McCall provided good advice with:
CommandBars("Menu Bar").Controls("View").Controls("Toolbars").Visibl e
= False

This worked fine in that in the View menu the Toolbars option is no
longer visible. When it is visible it leads to a submenu listing
toolbars and Customize...

What I had not realised (or had forgotten) is that this same submenu
is available by right clicking in the toolbar, even when the menu item
is no longer visible. How can I prevent this popup from appearing?
or at least edit its contents?

Aug 20 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Jim Devenish wrote:
I recently sought help about how to prevent some users from accessing
certain toolbars.

Stuart McCall provided good advice with:
CommandBars("Menu Bar").Controls("View").Controls("Toolbars").Visibl e
= False

This worked fine in that in the View menu the Toolbars option is no
longer visible. When it is visible it leads to a submenu listing
toolbars and Customize...

What I had not realised (or had forgotten) is that this same submenu
is available by right clicking in the toolbar, even when the menu item
is no longer visible. How can I prevent this popup from appearing?
or at least edit its contents?
If you want to control menu and toolbar access then the proper thing to do
is disallow ALL built in ones in Startup options and provide custom ones for
everything.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Aug 20 '08 #2

P: n/a
You can disable the right click on forms by using the properoty sheet.

And, I belive the tools->startup options will also disable the built in
menus..

You most certainly can, and should hide all of the ms-access interface. The
options to complete hide and keep people out of the ms-access interface can
easily be done using the tools->start-up options. Using those options allows
you to complete hide the ms-access interface (tool bars, database window
etc). Also, using these options means you do not have to bother setting up
security.

Try downloading and running the 3rd example at my following web site that
shows a hidden ms-access interface, and NO CODE is required to do
this....but just some settings in the start-up.

Check out:

http://www.members.shaw.ca/AlbertKal...s/DownLoad.htm

After you try the application, you can exit, and then re-load the
application, but hold down the shift key to by-pass the start-up options. If
want, you can even disable the shift key by pass. I have a sample mdb file
that will let you "set" the shift key bypass on any application you want.
You can get this at:

http://www.members.shaw.ca/AlbertKal.../msaccess.html
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
Aug 21 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.