Hide Show Menus and Toolbars

I have a form called frm_Logon that opens on database startup

In the On Open Event I have the following code:

Dim I As Integer For I = 1 To CommandBars.Count CommandBars(i).Enabled = False Next I

This should hide all toolbars and menus. However it has absolutely no effect. I have tried to change the false to true just to see what happened and there was no change.

I have used this for years and it has always worked. Can someone tell me what I am missing?

I am using Access 2003 on Windows

Sponsored Links:

Related Topics

Remove Menus and Toolbars
I want to make my DB look more stand-alone-ish. Found ghudson's (VBA) post on this site:

' This will hide all menu bars and tool bars
Dim I As Integer
For I = 1 To CommandBars.Count
CommandBars(i).Enabled = False
Next I

OUTSTANDING. If I'm running MSA 2003 it's like Access isn't even there (after a brief screen flash). However, when I try the software in MSA 2010 . the Menus/Toolbars remain


How do you hide top toolbars when open database - 2007
I want to hide the top toolbars when my users open my database in Access 2007! I have an autoexec macro to maximise the window which gets rid of the navigation bar on the side but cant work out how to hide the top bar? do I need to write code? if so what code and where would I input it.


Setting Up Right Click Menus for Access 2007
This article shows you how to apply and even create right click (Short Cut) Menus in Access 2007 even though Toolbars and Menus are not obvious in the user interface.


Custom Menus and Tool Bars2
Here, we will take a closer look at Custom Menu bars, Toolbars & Shortcut Menus. Since, it is a lengthy subject we are forced to split this into 2 or 3 Posts.


Custom Menus and Tool Bars
How to reference individual Button to enable/disable it based on situations that demands it.
Here, we will take a closer look at Custom Menu bars, Toolbars & Shortcut Menus.


Use Existing Custom Menus and Toolbars
This topic explains how custom toolbars and menu bars that you created in earlier versions of Access behave when you open those older databases in Microsoft Office Access 2007. This topic also explains how to turn off the Ribbon so that you can use just your custom toolbars and menu bars.
Learn how to use menu and toolbar customizations of databases created in earlier versions of Access.


Microsoft Access Articles
Topics: Distributing a Microsoft Access Application, Creating a Resolution Independent Microsoft Access Application, Custom Menus, Toolbars and Pop-Up Menus, repair/recover a corrupt database, use DAO with Microsoft Access 2000 or higher, handling images with Microsoft Access.


Converting AC2003 to AC2010 - Menus and Toolbars
I'm thinking of changing my AC2003 db to AC2010
My main concern now are the custom menu and toolbars.

Can I keep the old system ?
Can I have Menu and Sub-Menu?
Or should I better keep it as AC2003?

I don't like the new Ribbons

1. I know I'm not as smart as MS engineers, but In my point of view you should have the most common tasks on the toolbar and have the less common ones hidden in menus.
The new ribbons system works against this.
2. Using visual clues to find what you'r looking for is good, but it's not good in very crouded Environment. And it sure not very good at first when you have only very little idea how it should look like.
Try to find a person in a crouded party, when you only have little idea how he looks like. Sure he can hold a sign with his name, but what if all other persons do the same?
Isn't it much simpler to find him in the guess list, sorted alpahbet? Even if you don't know his exact name you sure have a good idea


Hiding forms/Menus in the back ground
I have three forms/menus

Each form/menu overlaps the other when selected.

Is there a way to hide the previous forms/menus not in present use?

I am afraid the user will click on a form that is in the back ground and not on the present form in use.


Show Print Ribbon In Report Preview, Office 2010
In my Access 2010 database I have disabled:
* Display Navigation Pane
* Allow Full Menus
* Allow default shortcut Menus

This gives the user a clean screen.

If I open a report in preview mode, how can I show the Print Preview ribbon to allow users to actually print or close the report.
And hide the Print Preview ribbon when the user closes the report.

I am using VBA

My reports are not pop-ups
My database is not on the web, but on a local network


Access 2007 - Hide Ribbons
Just upgraded from Access 2003 to 2007 and need to use the 2003 Customized MenuBars and ToolBars and hide the Standard 2007 Ribbons and Navigation Pane from the users. Is there a simple way to do this


Tools>Startup... MISSING
I was working in make custom menus/toolbars and now I do not have the Tools>Startup menu selection.
How do I get it back?


Work with the keyboard
Learn how to find a complete list of keyboard shortcuts for each Microsoft Office program and to use them in menus, in toolbars, and in the document itself. (Microsoft Access 2013)


Key equivalent to run macro
I have a database with the toolbars hidden. However, I created a button to run code to show the toolbars, then made the button transparent so only my primary user knows where it is.

However, since the button is on a form, she can't use the button unless that form is open. I would like to set up a key equivalent for the code so that she can display the toolbars any time she needs, then rehide them as necessary, from anywhere in the database. I've never set up key equivalents (like macros in Excel have) and need


Disable Form Design Mode
Can anyone tell me how to disable Design mode without going all the way to creating a mde or accde database? I'm running Access 2003. I have disabled shift key, Access Special Keys, Allow Full Menus, Allow Default Shortcut Menus. Each one gets me a little closer. I don't want to disable Allow Built-in Toolbars because the users need that to Filter by Form. However, the Design button is on that toolbar and that lets them get into Design Mode. I think if I can get the Design button off the toolbar, I'll be there


Disable Form Design Mode
Can anyone tell me how to disable Design mode without going the way to creating a mde or accde database? I'm running Access 2003. I have disabled shift key, Access Special Keys, Allow Full Menus, Allow Default Shortcut Menus.

Each one gets me a little closer. I don't want to disable Allow Built-in Toolbars because the users need that to Filter by Form. However, the Design button is on that toolbar and that lets them get into Design Mode.

I think if I can get the Design button off the toolbar, I'll be there.


Show or hide text
I have a access database. Sometimes I don't have any data to show in a column is there a way that is can hide that columm en show if there is data for it?


Can you disable all menus in vba?
Is it possible to disable menus and the bar down the side that allows you to navigate to different form, menus, tables, etc. using vba. I know I can disable the menus in Access Options, but I would like to allow a superuser login where I can turn all of this back on.


Design Mode Button?
I am trying to secure my application and I just noticed there is a group of icons in lower right side of window which will allow entry into design mode if full menus are allowed. Is there any way to hide/disable then entire group or just design mode button and still allow full menus?


Turn off Ribbon and hide all tables
In access 2007, how do I turn off the ribbon and hide all the tables and forms so that a general user can not access them? I know how to do this in 2003 but can't find the correct menus to do this in 2007. As always