How to Hide Ribbon Menu with VBA : MS Access 2010

[@jtflypegasus]

I appreciate you sharing your expertise in VBA access. Thank you!

[@scotsbhoy5144]

Thanks - just what I was searching for! Well explained and clear instruction.

[@charlenelaing3623]

Love It! Just what I needed. Thanks for Sharing

[@mariafavereaux782]

Just wanted to say Thank you!

[@jayblasi2454]

Really appreciate thee tips!

[@danielweber4961]

Perfect! Thanks a bunch!

[@syedabbas201]

Thanks dear I was Seeking This kind video..u solve my Problem

[@ashokanselliah9571]

Thank you very much! Very much useful for learner like me...

[@nedrarussell8772]

game changer!!! Thank you!

[@HauntHours]

thanks bro, i appreciate

[@eddypoppe2600]

Thank you very much !

[@123cookies4life345]

Hey Tewan, I'm a huge fan! Haha, I built a database today and your videos have helped me out a lot! Just wanna say thanks dude, awesome job

[@29884840]

Thanks a lot SIR!!!!!!

[@pervez51]

Excellent Thanks

[@MauricioNelson]

Genius ;)

[@serdip]

Hi. Great tutorial that teaches me just what I wanted to know: how to hid the Ribbon. But I think you should put the DoCmd statement in the Navigation Form's OnActivate event instead of its OnLoad event. That way, whenever the Navigation Form gets focus, it will hide the Ribbon automatically. The technique demonstrated in your video will require the developer to add code to the OnClose event of each report or form launched from the Navigation Form, which is not necessary, I believe. Thanks for the great videos!

[@austin72406]

it's good method. I will try it. Thank you for sharing.

[@DBDesignAndCode]

If you set this code on a login dialog box then you should not have this problem. Is that right Sir Austin72406?

[@erickb7753]

Thank you for your videos. Just wanted to know how not to hide the minimize/maximize/close box within the Tables that are maximized with a hidden Ribbon bar. The problem that I'm showing is that once a table is maximized I can't close the table to go back to view other tables besides closing the whole database.

[@ehteshamshah]

How to create our own customized Ribbon in Access like we did (Menu Bar) in Access 2003

[@imranward4092]

you have been amazingly healpful thus far. I wanted to ask how do you disable one tab on the ribbon through vba?

[@austin72406]

if name of your navigation button is AdminPage then you can put this code under the On Load Event on Form. Private Sub Form_Load() Me.AdminPage.Enabled = False End Sub

[@amirahsyuhada8559]

Hello sir. Im doing a project at ms access. i would like to hide the prompt "type mismatch" because all the data that i want already appear. How to hide the prompt? Thankyou.

[@michaelschweiger9772]

Hi Tewan, your video is really great! Thank you for sharing your helpful knowledge. “After putting “DoCmd.ShowToolBar "Ribbon” acToolbarNo” in my FORM, the Ribbon disappeared as supposed to be. But I still get the Toolbar (upper left corner) displayed. How did you get rid of the Toolbar in your Video? Could you please give me / us an advice what we have to do, to get rid of the Toolbar while displaying the Print Preview Screen. I really would appreciate your help! Best regards, Mike

[@imtiyazshaikh544]

Hello Sir, thank for such a wonderful video & it is helpful. But how this works in MS Excel 2010.

[@isackagble-clinton7792]

You saved me

[@syedabbas201]

I need one more Help About FIFO

[@javisu1975]

Hi Tewan The command DoCmd.ShowToolBar "Ribbon" acToolbarNo/Yes hides and shows the Ribbon. Is there a vba command with which it is possible to hide or show the navigation pane ?? instead of clicking Option and unchecking the check boxes

[@austin72406]

Hide with SetProperties "StartUpShowDBWindow", dbBoolean, falseyou need a SetProperties function which is shown on my video.it will take effect after program reopens. Show with SetProperties "StartUpShowDBWindow", dbBoolean, True

[@FareyFerrai]

Hi how to show this only on print preview? In my case i want show reports in report view as default. But i want show the ribbon when i change to print preview.

[@austin72406]

display Print Preview toolbar when report is loaded. Private Sub Report_Load() On Error Resume Next DoCmd.ShowToolbar "Ribbon", acToolbarYes End Sub Private Sub Report_Close() On Error Resume Next DoCmd.ShowToolbar "Ribbon", acToolbarNo End Sub

[@mirbektursunbekov6713]

HI Austin, thx to your video. I need your support for resolving this problem... it works when I'm opening my DB with SHIFT key, when I open my DB with just mouse double click, this method doesn't work... how to be in this case(when db is open with double click)?

[@FallenHoot]

+Mirbek Tursunbekov Right click and say Open well holding the "shift key"

[@EppBre]

Hey Tewan, I followed your instructions and everything works like in your video! But when I open a Report and the Navigation bar is open in the background, I can easily click on the Navigation bar and the Ribbon is there... :( [When I close the Report the Ribbon on the Navigation bar disappears how it is supposed to work!] Do you know a code to avoid this? it should be something like: when report oben, no ribbon active ...its not possible to put something like when report oben, no acces to navigationbar, because it might be necessary to oben more reports in the same time! Thanks a lot!

[@austin72406]

you can do like .. when open report make the form invisible (on click event of button, Put code as me.visible = false)then make form visible when report close (on close event of report, put code like forms!formname.visible = true)

[@EppBre]

austin72406 thanks for your answer! The problem is that the navigation bar needs to be visible to open if more than one Report... Do you know a code like "when Report open, noRibbon on navigationform"... I think that code should come on the NavigationForm Properties.. Thanks!

[@ApexRailAutomation]

Tewan, I have watched this video and "Hide database window, Hide menu, Disable shortcut menu, Disable Special Keys : MS Access". They are a HUGE help. Thank you very much. Many thanks I have a question. If I was to hide the Ribbon, database window, Hide menu, Disable shortcut menu, Disable Special Keys...How can I then get them back for editing the database? I'm scared to implement all this at once and lock myself out of the back end. Thank you for your time and help.

[@austin72406]

FIRST you have to make a copy of your database for testing. You already show you how to bring back all on the video. if you use password then don't forget password.

[@ApexRailAutomation]

+austin72406 Thank you, I will have to watch the video again. I also thought if creating a hidden button that is very small and the same color as the background. This would turn the ribbon back on.

[@jamsgh5076]

Hi thanks for your videos it's very useful. Can u please tell me how to do the same code in Access 2013. specially to hide navigation panel (Tables, form ...)

[@austin72406]

it should work with 2013.

[@jamsgh5076]

No. Not for the navigation tab(table, forms...)

[@FallenHoot]

+jamal sghayron You have to go to File --> Options --> Current Database --> Uncheck Display Navigation pane. That is how you do it.

[@jamsgh5076]

+FallenHoot ok thanks

[@abbasmuhamad3305]

Hi Tewan thanks a lot for your videos it's very useful for me I would like to be my friend on Facebook and I need you for tell me more about access 2010 and VBA. Really I need you.. thank you again....

[@austin72406]

sorry Abbas I don't have Facebook

[@DBDesignAndCode]

Austin72406 your tutorials are DA BOMB I originally posted this question on your iaccess website: www.iaccessworld.com/how-to-disable-properties/ Is there any way to integrate the enable/disable form views [design/layout] in the same functions for disabling ribbon menu? I do not want to user to be able to wander into the form layout. Also...I have a memo field in one form that I would like the user to be able to change color on the rich text. Can I conditionally enable just the ribbon for font size/color when that form is open? I had also read that key commands can be linked to a font color change like Ctrl+Shift+M for example. Also I do not like the input box because there does not seem to be a way to have a password mask . I made a new form with password mask on text box. Same concept with the password: correct value calls the enable properties. I could not get a message box to count the attempts without giving the user a chance to alter the input on the form. The loop code just loops through 3 attempts if you go my route...as of now....so I just do not use that part of the code. I like the idea though of showing the user their attempts left and desire more sophistication than what I have now..

[@imtiyazshaikh544]

Hello Sir, thank for such a wonderful video & it is helpful. But how this works in MS Excel 2010.

[@imtiyazshaikh544]

Hello Sir, thank for such a wonderful video & it is helpful. But how this works in MS Excel 2010.

[@austin72406]

it should work the same as Access. Put hide Ribbon code under the Open file procedure