Solved Accdb: Ribbon and NavigationPane, Unhide/hide (1 Viewer)

vhung

Member
Local time
Today, 08:07
Joined
Jul 8, 2020
Messages
159
>when you need to open you ribbon and navigation pane
>try the codes below

DoCmd.SelectObject acTable, , True
If Not (objPane Is Nothing) Then
objPane.IsCollapsed = False
End If
DoCmd.ShowToolbar "Ribbon", acToolbarYes 'Yes or 'No
MsgBox "Ribbon, acToolbarYes; NavigationPane OpenYes"

>no need to restart this time auto response is visible
 

Attachments

  • rpview.png
    rpview.png
    268.9 KB · Views: 18
Last edited:

vhung

Member
Local time
Today, 08:07
Joined
Jul 8, 2020
Messages
159
>use this sample codes for hide command

DoCmd.ShowToolbar "Ribbon", acToolbarNo 'Yes or 'No
MsgBox "Ribbon, acToolbarNo; NavigationPane OpenNo"

CommandBarControl.Visible = False
DoCmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide

>no need to restart this time auto response is visible
 

Attachments

  • rpviewx.png
    rpviewx.png
    207.3 KB · Views: 13
Last edited:

Users who are viewing this thread

Top Bottom