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

Customize your toolbars and menus
Learn how to change existing toolbars and menus, including the shortcut menu, and how to create your own toolbars and menus in Microsoft Office programs.
After completing this course you will be able to:
1) Move toolbars and menus.
2) Modify an existing toolbar or menu.
3) Create a toolbar customized to your needs.
4) Design your own menu.
5) Customize a shortcut menu (Microsoft PowerPoint, Word, and Access only).
6) Reset menus and toolbars to the default settings.
(Microsoft Office Access 2003)


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


Troubleshoot toolbars
My built-in toolbars and menus have disappeared. I want to return built-in toolbars that came with Microsoft Access to their original settings. I'm having trouble either pasting or resetting an icon image onto a menu or toolbar. I can't customize a toolbar. I can't see my entire toolbar on the screen. I can't show or hide a toolbar, menu bar, or shortcut menu. I can't find a menu command, toolbar button, or dialog box option. I created a custom toolbar and shared it with another person, but it looks different on their computer.


Menus and toolbars
Displaying only the commands and buttons that you use, Displaying all the commands on a menu, Positioning toolbars on the same row, Seeing all of the toolbar buttons, Customizing menus and toolbars, Customizing your applications.


Control the display of all built-in toolbars and menus
You can control whether built-in toolbars, the built-in menu bar, or built-in shortcut menus are available in a Microsoft Access file.


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.


Import menus and toolbars
You can import custom menus and toolbars from a Microsoft Access database or Microsoft Access project. However, Access won't import a toolbar, menu bar, or shortcut menu if it has the same name as one in the Access data file you're importing to - you must rename it before importing.


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.


Control whether some or all of the built-in menus are displayed
If the Microsoft Access file you're creating provides the user access to the built-in menus, you can choose to display only a predefined subset of the menus. That way, you can hide menus, such as View and Insert, that would enable a user to access the Design view of objects in your Access database or Access project and to change their design.


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 2003)


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