NavigationPane Access

[jero]

Hello,
How to hide the navigation pane in vba ?
Only with : DoCmd.RunCommand acCmdWindowHide ?
It's not possible with something like :
CurrentDb.Properties("Something ?").Value=????
Other :
Is it possible (in vba) to hide the ribbon ?
Thank's in advance
jpg

 

[Arvin Meyer [MVP]]

Hello,
How to hide the navigation pane in vba ?
Only with : DoCmd.RunCommand acCmdWindowHide ?
It's not possible with something like :
CurrentDb.Properties("Something ?").Value=????
Other :
Is it possible (in vba) to hide the ribbon ?

DoCmd.ShowToolbar "Ribbon", acToolbarNo

 

[jero]

Hello and thank for the answer,
The command DoCmd.ShowToolbar "Ribbon", acToolbarNo doesn't hide the
navigation pane (only the ribbon)
Sorry for my english..
jpg

 

[Albert D. Kallal]

Hello and thank for the answer,
The command DoCmd.ShowToolbar "Ribbon", acToolbarNo doesn't hide the
navigation pane (only the ribbon)
Sorry for my english..
jpg

Arivn has given you a great way to hide the ribbon and office button.

To hide the nav pane, start ms-access and the application up (use the shift
key to by-pass your startup that hides everything).

Now, office (pizza) button
then lower right you see "access options"

then current database.

You see an section called navigation..and there is a option you can un-check
that says to display the navigation pane.

So, to work etc, just hold down the shift key, and you have the full ribbon
and nav pane. However, in your start form, if you execute your command, then
you not see ribbon, office button nor the nav pane...

 

[jero]

Thank's

Arivn has given you a great way to hide the ribbon and office button.

To hide the nav pane, start ms-access and the application up (use the
shift key to by-pass your startup that hides everything).

Now, office (pizza) button
then lower right you see "access options"

then current database.

You see an section called navigation..and there is a option you can
un-check that says to display the navigation pane.

So, to work etc, just hold down the shift key, and you have the full
ribbon and nav pane. However, in your start form, if you execute your
command, then you not see ribbon, office button nor the nav pane...