Solved

access navigation pane hide with vba

Posted on 2010-08-27
9
1,256 Views
Last Modified: 2013-11-28
Hello,

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

Thanks
0
Comment
Question by:JoeBlack1980
  • 3
  • 2
  • 2
  • +2
9 Comments
 
LVL 18

Accepted Solution

by:
Cluskitt earned 250 total points
ID: 33541447
0
 

Author Comment

by:JoeBlack1980
ID: 33541612
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
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 33541880
see the accepted solution here.
0
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
LVL 31

Assisted Solution

by:Helen_Feddema
Helen_Feddema earned 125 total points
ID: 33542154
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
 
LVL 31

Expert Comment

by:Helen_Feddema
ID: 33542160
They are functions so they can be run from hot keys in the AutoKeys macro, for convenience.
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 125 total points
ID: 33542566
"however when i use it on mine,"
Is your form "Pop up" property set to: Yes?
0
 

Author Comment

by:JoeBlack1980
ID: 33574902
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
 

Author Closing Comment

by:JoeBlack1980
ID: 33574912
Had to use multi replies to get one final solution.But thanks everybody.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 33577719
"Had to use multi replies to get one final solution"= Collaboration

;-)

Jeff
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question