Hide Show Menus and Toolbars
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
Thank you for taking the time to report an issue.
What's wrong... Please write below.
' This will hide all menu bars and tool bars
Dim I As Integer
For I = 1 To CommandBars.Count
CommandBars(i).Enabled = False
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
Here, we will take a closer look at Custom Menu bars, Toolbars & Shortcut Menus.
Learn how to use menu and toolbar customizations of databases created in earlier versions of Access.
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
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.
* 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