can I get rid of all access menus?

A

alekm

Hi,
is there any chance I can skip all access menus in my database. I can't get
rid of:

File Edit Insert Recors Window Help

Thanx
 
A

Albert D. Kallal

The best approach is to hide all of the ms-access menus, and simply make you
own.

I have a small sample in a2000 that hides everything.

It is nice example because no code, or security is needed to accomplish this
(you use the tools->startup options).

Try downloading the 3rd example here:
http://www.attcanada.net/~kallal.msn/msaccess/DownLoad.htm

I might not be exactly what you want to do..but it will give you some
ideas...
 
6

'69 Camaro

Hi.

You can avoid using the default Access menu bar by assigning your own custom
menu bar. First, create your own custom menu bar that has only the menu
options that you want your users to see. Next, select the Tools menu ->
Startup... to open the "Startup" dialog window. Uncheck the "Allow Full
Menus" check box. Select the name of your custom menu in the "Menu Bar:"
combo box. Select the "OK" button to save your changes.

The next time the database is opened, your custom menu bar will display
instead of the built-in Access menu bar. Bear in mind that people can use
the <SHIFT> key during startup to avoid your startup settings, unless you
prevent them from doing so. You can find the code for disabling the
AllowBypassKey on this Web page:

http://www.mvps.org/access/general/gen0040.htm

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Any human can read my reply E-mail address and should alter it so that a
message will be forwarded to me. Spammers are free to use my UNALTERED
reply E-mail address. I will *never* get those messages!)
 
6

'69 Camaro

You can create a custom command bar very easily (command bars now include
both menu bars and toolbars in more recent versions of Access). Please see
the "How to add a custom button on the command bar to run code on a form"
tutorial on this Web page:

http://www.Access.QBuilt.com/html/forms.html#CustomCmdBar

This tutorial instructs how to create the command bar and add a custom
function to that command bar. However, the custom command bar does not
require custom functions, since one can easily drag items (such as menu
items and toolbar buttons) in the list box within the "Customize" dialog
window to the custom command bar to add whatever Access built-in
functionality you may need.

Also, see the "Useful toolbar buttons for repositioning/resizing groups of
controls quickly" tip for how to quickly and easily copy menu items from the
Access built-in menu bars to your own custom menu bar on this Web page:

http://www.Access.QBuilt.com/html/gem_tips.html#ToolbarBtns

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Any human can read my reply E-mail address and should alter it so that a
message will be forwarded to me. Spammers are free to use my UNALTERED
reply E-mail address. I will *never* get those messages!)
 
Top