PDA

View Full Version : Hide Navigation Pane on Single Form Only



Breanna
01-09-2015, 01:10 PM
I am using the below vba to hide the ribbon for just one form while that form is open. Is there a way to use the same command to hide the navigation pane?

Private Sub Form_Load()


DoCmd.ShowToolbar "Ribbon", acToolbarNo




End Sub

bbotzong
01-15-2015, 08:52 AM
Found this doing a quick google search...

(wouldn't let me post a link, so I'll copy paste article from msdn)

‘ hide
Private Sub Command1_Click()
DoCmd.NavigateTo "acNavigationCategoryObjectType"
DoCmd.RunCommand acCmdWindowHide
End Sub
‘unhide
Private Sub Command2_Click()
DoCmd.SelectObject acTable, , True
End Sub



Should help

Breanna
01-15-2015, 09:16 AM
Found this doing a quick google search...

(wouldn't let me post a link, so I'll copy paste article from msdn)

‘ hide
Private Sub Command1_Click()
DoCmd.NavigateTo "acNavigationCategoryObjectType"
DoCmd.RunCommand acCmdWindowHide
End Sub
‘unhide
Private Sub Command2_Click()
DoCmd.SelectObject acTable, , True
End Sub



Should help

That did work yes!
Just real quick you had 'hide is that something that can actually be added in the code just as text to show what the next line/section is for?