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,
Ken.
P.S. Also is it possible to set a minimum window size that resizing will not go below?
21  62467  Megalog 378
Recognized Expert Contributor
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!
ChipR 1,287
Recognized Expert Top Contributor
Try: DoCmd.ShowToolb ar "Ribbon", acToolbarNo
Megalog 378
Recognized Expert Contributor
Sweet! Learn something new every day.. tested it, works perfect.
Thanks ChipR, worked perfectly! Much appreciated
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?
Megalog 378
Recognized Expert Contributor
I would think the opposite parameter would bring the ribbon back, like: - DoCmd.ShowToolbar "Ribbon", acToolbarYes
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...o therwise you can't access the ribbon to do your work.
What about creating the simple Macro implied and setting it to a key combination like SHFT+Ctrl+F12.
DoCmd.ShowToolb ar "Ribbon", acToolbarYes
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!
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.
share your valuable ideas.
Thanks in advance.
Regards,
|
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 could add your own. Reason
being, I have a setup options screen, and a backup utility that would go
perfectly there for my custom app. As it stands, I'm not quite sure where to
put them, or where to put an old-style "File, Register..." type screen...
|
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 the user in a
custom application.
Can it be disabled or hidden and if so, how?
|
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 bring it up
using F11.
But what good does that do me if the users can just click on the
Office Button and then Access Options and reverse those settings? Not
much, but I can't seem to find a way to hide the Access Options
button. I know I can...
|
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 to
search online for a keyboard shortcut to be able to access Design Mode
at all.
I'm sure there is something I'm missing, but it doesn't make sense. I
can add and remove other buttons from the toolbar, why not Mode??
|
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 -- open an
existing one.
My application is on a terminal server and I'm trying to plug all the
holes so the user can't do anything but use my application. But right
now if the user goes to the Office Button and clicks "Open", he can
navigate to...
|
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 minimize buttons as well. Is there a simple command I can use to disable just this button or any way I can adapt the cited post to do just that?
Kind regards,
Ken.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| | |
