• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1284
  • Last Modified:

access navigation pane hide with vba

Hello,

Is there any way in access 2007 to hide  navigation pane with VBA, and without need to restart the database?

Thanks
0
JoeBlack1980
Asked:
JoeBlack1980
  • 3
  • 2
  • 2
  • +2
3 Solutions
 
JoeBlack1980Author Commented:
hello,
it works very well in example db , however when i use it on mine, it shows navigation panel, then on hide, it hides the window on which i use the button.
Any ideA?
0
 
Dale FyeCommented:
see the accepted solution here.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Helen FeddemaCommented:
I use these little procedures:
Public Function ShowNavPane()

   DoCmd.SelectObject objecttype:=acTable, indatabasewindow:=True
   
End Function

Public Function HideNavPane()

   DoCmd.RunCommand acCmdWindowHide

End Function

Open in new window

0
 
Helen FeddemaCommented:
They are functions so they can be run from hot keys in the AutoKeys macro, for convenience.
0
 
Jeffrey CoachmanCommented:
"however when i use it on mine,"
Is your form "Pop up" property set to: Yes?
0
 
JoeBlack1980Author Commented:
Ok ,
Thanks all for the replied,
For anyone who will visit this question later on  , I had to combine all the replies so it goes like that.
I use the form in the 1st reply, i set up the property to PopUp.
Then in another window , i make a button which uses the following code
DoCmd.OpenForm "form11"
DoCmd.Close acForm, "form11", acSaveNo
And i set the Form_Load event code of form11 as following>
Private Sub Form_Load()
DoCmd.SelectObject objecttype:=acTable, indatabasewindow:=True
DoCmd.RunCommand acCmdWindowHide
End Sub
 That way , the button i created open form11 which hides navisgationpane, and then later it close form11
It's kind of walktrough, but it works fine for me
Thanks all
0
 
JoeBlack1980Author Commented:
Had to use multi replies to get one final solution.But thanks everybody.
0
 
Jeffrey CoachmanCommented:
"Had to use multi replies to get one final solution"= Collaboration

;-)

Jeff
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now