Thank you so much. I've been waiting for a small miracle like this.
The ribbon is a blessing for the new, and a bane for the old, as it simultaneously makes itself easier to use and harder to break. The lack of easy customization is hopefully going to be remedied, but I'm certainly not holding my breath.
Discussion on:
View:
Show:
That's the complaint I hear most from Office 2007 users -- many of them don't mind the new ribbon as an interface tool, but it sure does play havoc with development. 
When I try it I get the compile error:
Variable not defined
with "Ribbon" selected
So I wonder if there is a missing object library reference - do you know which reference is needed for the toolbarname "Ribbon" ?
Variable not defined
with "Ribbon" selected
So I wonder if there is a missing object library reference - do you know which reference is needed for the toolbarname "Ribbon" ?
I'd rather minimise it than completely hide it - I still want the menus. Trouble is while you can do that by double clicking a tab or by pressing CTRL-F1, I can't do this from Visual Basic. I can customise menus in XML, but can't see how to minimise the ribbon. Sendkeys would have been the obvious answer, but Microsoft killed that off with Vista. So the Excel dictator applications we make end up losing four rows of real estate to blank ribbon space. That's progress for you... (by Microsoft definition anyway)
This is a poor way to hide the ribbon in Access, removes the Office button as well...how would a user print a report when in preview mode, if the Office button is hidden?
Better to just add a custom blank ribbon to your application. That way you don't have any space lost and the normal Office button is still available. When doing development, just start the app with the shift key down to get the normal ribbon back.
Better to just add a custom blank ribbon to your application. That way you don't have any space lost and the normal Office button is still available. When doing development, just start the app with the shift key down to get the normal ribbon back.
Not the best way to do this, use the Application.SendKeys ("^{F1}") command, and add to the QAT. This toggles the Ribbon On & Off
The same command is already available as minimise ribbon under Customise Quick Access Toolbar. It doesn't take away the ribbon, the tabs are still there, and the ribbon will expand again while you select one.
But while sendkeys is flaky at best, it's disabled in Vista
But while sendkeys is flaky at best, it's disabled in Vista
That is great thanks, I have been looking for something like that for a long time.
A more detailed answer which includes information about running Access 2003 programs under Access 2007, and about using a simple custom ribbon in Access 2007 format databases may be found at:
http://www.mooresw.com/hide_or_eliminate_the_ribbon_programatically_in_microsoft_access_2007.php
http://www.mooresw.com/hide_or_eliminate_the_ribbon_programatically_in_microsoft_access_2007.php
I used the following code in the open event of my login form (form that opens initially)
SendKeys "^{F1}", True
SendKeys "^{F1}", True
SendKeys "^{F1}", True :
Not perfered since this will not work for your application becuase once you initiate the form more than once.. it will bring the ribbon back.. it dose not know the ribbon should stay hidden..
If you wanna cheat... just set the form to activiate as a "Pop-up" form.. this will hide some form functions..ie..window control.. but will not show the "Ribbon"..
..just a thought..
I am also getting an "Variable not defined" error with the docmd function.. something is missing and it would be nice to have the complete code or reference in this thread also!
Naeem
xcodecorp~
"There are only 10 people who know binary, those who do and those who dont."
Not perfered since this will not work for your application becuase once you initiate the form more than once.. it will bring the ribbon back.. it dose not know the ribbon should stay hidden..
If you wanna cheat... just set the form to activiate as a "Pop-up" form.. this will hide some form functions..ie..window control.. but will not show the "Ribbon"..
..just a thought..
I am also getting an "Variable not defined" error with the docmd function.. something is missing and it would be nice to have the complete code or reference in this thread also!
Naeem
xcodecorp~
"There are only 10 people who know binary, those who do and those who dont."
- Keyboard Shortcuts:
- Prev
- Next
- Toggle
