472,809 Members | 4,824 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,809 software developers and data experts.

Disable ribbon, office button & quick access toolbar

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
21 62229
378 Expert 256MB
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
1,287 Expert 1GB
Try: DoCmd.ShowToolbar "Ribbon", acToolbarNo
Nov 24 '08 #3
378 Expert 256MB
Sweet! Learn something new every day.. tested it, works perfect.
Nov 24 '08 #4
Thanks ChipR, worked perfectly! Much appreciated
Nov 27 '08 #5
269 256MB
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
378 Expert 256MB
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
269 256MB
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
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
269 256MB
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
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
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
157 100+
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
234 Expert 100+
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

Where should i write this code for the quick access toolbar?? Is it a vba code or custom UI?
Aug 12 '14 #15
3,653 Expert Mod 2GB
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
269 256MB
It is VBA code and I have it in OnOpen and OnClose (when opening and closing forms).
Aug 12 '14 #17
2 2Bits
this is NOT working to fully hide the ribbon or the QAT in Access 2019. in fact if you click the right side of the QAT it gives you the opportunity to go right to the Access options and you can reset anything you want in the accde.

Which means attached tables are no longer hidden and queries can be created to edit data without forms.

Any other ideas?
May 31 '21 #18
438 Expert Mod 256MB
It is definitely possible to remove the ribbon and with it the QAT as well as other items such as Access options and the navigation pane.
Unfortunately the QAT is always visible if you use any ribbon, whether a standard Access ribbon or your own customised ribbon. However, whilst it is visible, the QAT can be disabled

Please read my articles Improve Security in Access databases and Control the Application Interface for full details including all required code.
May 31 '21 #19
2 2Bits
thank you thank you thank you
Jun 2 '21 #20
438 Expert Mod 256MB
Hi @scarlson
Not sure whether that was directed at me, but pleased to see you got something useful out of this thread
Jun 2 '21 #21
32,534 Expert Mod 16PB
Your original post in this thread was a hijack so I would have deleted it if I'd seen it. Now it's been responded to and the answer may prove helpful so I'm going to leave it in play. Very unfortunately, almost no-one will ever see it BECAUSE you posted it in a completely unconnected thread. Hey ho.

Generally speaking, when we see hijack questions posted in threads that were created for other members / reasons then rather than replying to them it's better practice to Report them. That way the OP can post them properly and others will find them later. There is some leeway allowed when the subsequent question(s) are from the same member who created the thread but even then that is not a free pass for any question. Who can find these gems when they're tucked away in unrelated threads without a matching title?
Jun 7 '21 #22

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

Similar topics

by: prabhukrs | last post by:
hi friends, I'm working with Asp.Net application.I need to disable the refresh buton in the IE's toolbar using code, so that the refresh button could be diabled at runtime when it goes live. ...
by: ARC | last post by:
Does anyone know if you can add your own items to the round office button in the top left? I'm guessing the answer is no, and that you can only hide the default items, but it would be great if you...
by: Wayne | last post by:
I've searched this forum and trawled the wider web and can't find any information on how to hide or disable the A2007 Quick Access Toolbar. The toolbar is not something that one wants available to...
by: dstork | last post by:
In Access 2007, does anyone know of any code to position the QAT below the ribbon? This can be done manually but what about through code? ds
by: Bob | last post by:
Hi, Can it's possible to use a customized QAT in Access 2007 with a Ribbon using "USysRibbons" ? because in Access options i can't select 2 ribbon name. Thank's
by: evenlater | last post by:
I'm building an application using A2K7 and I need to be able to hide the navigation pane from my users. That's easy. I just hide it using Access options and then disable special keys so they can't...
by: Heather | last post by:
I keep selecting and selecting, but it just doesn't show up. I also have no button in the ribbon for this, or any ability to get into other modes via the Office button. It's very frustrating; I had...
by: evenlater | last post by:
I have an .accde file with custom ribbons and with "Allow Full Menus" set to False, but the Office Button menu still gives the user the ability to create a new Access database, or -- much worse --...
by: convexcube | last post by:
Hi everyone, Now that I've found a way to disable the ribbon etc. I need to disable the application maximize button. I have looked at this post and implemented it, but it disables the close and...
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Sept 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
by: DJRhino1175 | last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
by: Mushico | last post by:
How to calculate date of retirement from date of birth

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.