Topics Search

Hide Show Menus and Toolbars

Hide Show Menus and Toolbars
Views: 18
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:

More 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