Hiding menu, ribbons and navigation areas in Access 2007/2010

[Meteo]

Hi all,



I have developed a form that will open when the database opens and I would like this to be the only option open to the client to use. As a result I would like the ribbons/menus/navigation areas to be hidden. i tried this code but nothing happened.

Dim i As Integer
For i = 1 To CommandBars.Count
CommandBars(i).Enabled = False
Next i

Also tried this:

DoCmd.ShowToolbar "Menu Bar", acToolbarNo

I am a newbie so any help is appreciated.

Meteo

[rpeare]

if you're hiding the ribbon you'd likely need:

DoCmd.ShowToolbar "Ribbon", acToolbarNo

EDIT: if your user is going to be using a prior version of access this likely would have to be adapted to hide the 2003 toolbar as well

[Meteo]

Thanks I will give it a go. Do you know why the "DoCmd.ShowToolbar "Menu Bar", acToolbarNo" didn't work?

Meteo

[rpeare]

Because menu bar is from versions of access prior to 2007 when they were still referred to as toolbars.

Everything is ribbons with MS access now, which is why I said if your user is using an older version of access you'll likely have to still use the hide menu bar even though it does nothing in your design view (because you're using a newer version)

[Meteo]

Thanks very much, that seem to do the job. Is there a way to just show the forms that I create and hide the whole access window. I have three tiers of forms Parent -> child -> grandchild and they can call their parents back. I have split the database and plan to have an executable to run the frontend.

[rpeare]

http://www.pcreview.co.uk/forums/hid...-t3730764.html

First response down.

However, if you plan to have an 'executable' I'm assuming you mean run time components installed on the user's machine, the database window will not be visible to them anyway. When someone has the run time components only they can't mess around with the design of anything or the content of anything other than going through the interface you generate for them.

[Meteo]

Thanks very much for your prompt replies. That wraps up this thread.