Improve company productivity with a Business Account.Sign Up

x
?
Solved

Minimize Navigation Pane Access 2007

Posted on 2010-08-21
8
Medium Priority
?
1,053 Views
Last Modified: 2013-11-27
Is there a way in code or macro to minimize  the navigation pane?  Still want to be able to click on it if needed.  Just want it to open my form with the navigation pane minimized.
Thanks, Pat
0
Comment
Question by:PatKung
  • 3
  • 3
  • 2
8 Comments
 
LVL 18

Expert Comment

by:Cluskitt
ID: 33491986
DoCmd.SelectObject acForm, , True
RunCommand acCmdWindowHide

In this case, you select the nav panel. Then hide it.
0
 

Author Comment

by:PatKung
ID: 33491991
<In this case, you select the nav panel. Then hide it.>
How do I select the nav panel in code?

Thanks, Pat
0
 
LVL 18

Expert Comment

by:Cluskitt
ID: 33492024
Code for a couple buttons to show/hide pane (adapt to your own code needs):

Private Sub cmdShowNavigationPane_Click()
DoCmd.SelectObject acTable, , True
End Sub

Private Sub cmdHideNavigationPane_Click()
DoCmd.NavigateTo “acNavigationCategoryObjectType”
DoCmd.RunCommand acCmdWindowHide
End Sub


I haven't tested this to see if it works, but I don't see why it shouldn't.
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 1000 total points
ID: 33492069
0
 

Author Comment

by:PatKung
ID: 33492179
You both appear to be hiding it.  What if I just want to minimize it.  Is there a way?  Still want to see the >> to open it back up,
Thanks, Pat
0
 
LVL 18

Assisted Solution

by:Cluskitt
Cluskitt earned 1000 total points
ID: 33492199
Try DoCmd.Minimize
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 33492216
oh,, sorry.. it should  be docmd.minimize instead of  DoCmd.RunCommand acCmdWindowHide

like what Cluskitt posted..
0
 

Author Closing Comment

by:PatKung
ID: 33492514
Thanks guys!
Pat
0

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
What to do if a split doesn't fit? Or a bunch of invoice lines must be rounded while the sum must match a total? It takes a little, but - when done - it is extremely easy to implement.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

584 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