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?
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.