By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,846 Members | 1,448 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,846 IT Pros & Developers. It's quick & easy.

Disable ribbon, office button & quick access toolbar

P: 47
Hi everyone,

I am trying to create a single window interface for my database. As I am using Access 2007, I have my document layout options set to tabbed documents without displaying documents tabs in order to get my main form to appear as the only element in the access application window. I have also set anchoring in the form so that controls that should always be visible are and others stretch to adjust to the size of the window. When resizing the window the ribbon, office button & quick access toolbar disappear when the window goes below a certain height. Does anyone know how to disable these controls permanently so they don't appear when I enlarge the window?

Kind Regards,


P.S. Also is it possible to set a minimum window size that resizing will not go below?
Nov 24 '08 #1
Share this Question
Share on Google+
16 Replies

Expert 100+
P: 378
Getting rid of the ribbon, office button, and QAT aren't possible, as far as I know. I can tell you how to add/remove items from each, but I have never seen anyone say exactly how to disable or remove them entirely. I've seen many discussions on the web, mostly around when Office 2k7 was in beta, griping about how we're stuck with the Office interface. I havent seen anything new since then.

If you find anything newer, please let me know!
Nov 24 '08 #2

Expert 100+
P: 1,287
Try: DoCmd.ShowToolbar "Ribbon", acToolbarNo
Nov 24 '08 #3

Expert 100+
P: 378
Sweet! Learn something new every day.. tested it, works perfect.
Nov 24 '08 #4

P: 47
Thanks ChipR, worked perfectly! Much appreciated
Nov 27 '08 #5

P: 259
Thank you ChipR, this worked for me too.
Does anyone know if there is a way to get the ribbon to come back without removing the code?
Nov 9 '09 #6

Expert 100+
P: 378
I would think the opposite parameter would bring the ribbon back, like:

Expand|Select|Wrap|Line Numbers
  1. DoCmd.ShowToolbar "Ribbon", acToolbarYes
Nov 9 '09 #7

P: 259
Good point Megalog. I was hoping for a keyboard shortcut. I guess the moral of the story is don't put in this code in until your DB is ready to be implemented...otherwise you can't access the ribbon to do your work.
Nov 9 '09 #8

P: 3
What about creating the simple Macro implied and setting it to a key combination like SHFT+Ctrl+F12.

DoCmd.ShowToolbar "Ribbon", acToolbarYes
Nov 25 '09 #9

P: 259
I like that idea dpminusa. I will try that. I don't know how to set a macro to a keyboard combination but I'd like to try to figure it out on my own before I ask a question on it. Thanks!
Nov 25 '09 #10

P: 3
OK. I have it working with a passworded Form. Other articles I have seen recommend the Keyboard Idea also.

Let me know how it goes.

This is a follow-on to Megalog's suggestion.
Nov 25 '09 #11

P: 1
Normally I have a "Menu" form in my applications so if you have something similar, you could always have the "On Activate" event hide the toolbar ( DoCmd.ShowToolbar "Ribbon", acToolbarNo)
and then set the "On Close" event to show it again (
DoCmd.ShowToolbar "Ribbon", acToolbarYes)

If you hold down the shift key when clicking to open your access application, the toolbar will be there.
Mar 2 '10 #12

P: 157
DoCmd.ShowToolbar "Ribbon", acToolbarNo

Someone know why this dosent work for .accde files? Only .accdb files works for me

Edit: Forget it. Access fucked something up so nothing of the code worked in my .accde.
I dont know what Access does, but when i open Accdb and run VBA compile then one form opens in design mode, but without the 'x' in the corner to close it. It then cannot ble closed and you must close the database. This is only the symptom. Problem is solved when you rename the form, run debug, then rename back.
Mar 2 '10 #13

Expert 100+
P: 234
My databases all have tables that give users permissions for functions, forms, reports, etc. I'd set up some code to show the ribbon to anyone with developer level access and hide it for anyone without it.
Mar 3 '10 #14

P: 1

Where should i write this code for the quick access toolbar?? Is it a vba code or custom UI?
Aug 12 '14 #15

Expert Mod 2.5K+
P: 3,388
All, it is possible to make these settings just after creating the MDE file. There are a few details in this link: Working with Front Ends and Back Ends.

One can also create custom Ribbons which only show up for Reports. This is a little more involved than the current thread, but is worth looking into if you want to lock down your DB, as I often like to do.
Aug 12 '14 #16

P: 259
It is VBA code and I have it in OnOpen and OnClose (when opening and closing forms).
Aug 12 '14 #17

Post your reply

Sign in to post your reply or Sign up for a free account.