Disable ribbon, office button & quick access toolbar

[convexcube]

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?

[dpminusa]

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.

[ironjohn04]

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.ShowToolb ar "Ribbon", acToolbarNo)
and then set the "On Close" event to show it again (
DoCmd.ShowToolb ar "Ribbon", acToolbarYes)

If you hold down the shift key when clicking to open your access application, the toolbar will be there.

[MrDeej]

DoCmd.ShowToolb ar "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.
Strange!

[topher23]

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.

[Faestrad]

Hey

Where should i write this code for the quick access toolbar?? Is it a vba code or custom UI?

[twinnyfo]

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.

[DanicaDear]

It is VBA code and I have it in OnOpen and OnClose (when opening and closing forms).

[SCarlson]

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?

[isladogs]

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.

[SCarlson]

thank you thank you thank you