Hidding the Ribbon

[speakers_86]

I hid the ribbon using this method. Under access options, when I select HideTheRibbon, is this an action will stick during distribution? Or do I need to set this property upon startup? If it doesn't stick, how do I set it in vba?

 

[NigelShaw]

Hi,

the method you have used will hide the ribbon but only the standard ribbons within Access. the 'StartFromScratch = True' only allows your custom ribbon to be visible and this will follow through to your distribution. If you want to hid the complete ribbon, you need to use a different method. Do a search on my name and there you should find a post called something like "Hiding your ribbon Yay". that should help you out.

cheers


Nidge

 

[NigelShaw]

Found it,

http://www.access-programmers.co.uk/forums/showthread.php?t=206281


cheers

N

 

[speakers_86]

I just posted this twice on your link, before I realized it has to be approved by a mod.

Thanks Nigel. Code works great, I am just having trouble getting it to hide objects on form open.

Dim strFormHome As String
strFormHome = "frmHome"
DoCmd.SelectObject acForm, strFormHome, True
DoCmd.RunCommand acCmdWindowHide
DoCmd.ShowToolbar "Ribbon", acToolbarNo

This works if I shift bypass, enable vba, and open frmHome manually. However, if I let Access open the form by itself, then I enable vba, everything is hidden but the Home tab in the ribbon. Any ideas whats going on? It seems the only difference is whether the form is opened before or after vba is enable.

I don't have the ability to change trusted locations on this computer.

edit- I don't know what the issue was, but I created a new db and imported all the objects. This issue is gone, but replaced with an unrelated issue!