Results 1 to 7 of 7
  1. #1
    Toasty is offline Novice
    Windows Vista Access 2007
    Join Date
    Jun 2014
    Location
    The Netherlands
    Posts
    18

    Using buttons to hide/unhode the navigation pane

    Good morning,

    I would like to hide/unhide the navigation pane completely by using two buttons (pop the hood & close the hood) in a form. At this moment I used the following code:
    Private Sub Command77_Click()
    DoCmd.SelectObject acTable, , True
    DoCmd.RunCommand acCmdWindowHide

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

    This however makes my form shut down and not my navigation pane.



    Anyone?

    Regards,

  2. #2
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    You can try this. Also, remember to disable the Special Keys in your db options. Of course change to your table name.



    DoCmd.SelectObject acTable, "tblMyTable", True
    DoCmd.RunCommand acCmdWindowHide


    HTH

  3. #3
    Toasty is offline Novice
    Windows Vista Access 2007
    Join Date
    Jun 2014
    Location
    The Netherlands
    Posts
    18
    I seem to have found the anwer myself. It is important to make sure that the category where the selected object is in, is folded out. Seems a bit strange but that is the reason that sometimes this action does not work.

    Second question is :Is there an action to unfold a category (custom or standard?) in the navigation pane?

    Regards,

  4. #4
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    I don't understand your questions? What do you mean by category and unfold? Second Question? As you say, is the Navigation Pane now hiding as you wished or not?

  5. #5
    Toasty is offline Novice
    Windows Vista Access 2007
    Join Date
    Jun 2014
    Location
    The Netherlands
    Posts
    18
    Yes it is hiding however there is a but... it is hiding if the "Category" (standard this is "Tables", "Queries", "Reports" and "Forms" are unfolded/expanded.

    I will try to explain:

    Let's say I have directed (as you proposed) to the table "tblMyTable". This table will be standard in the category "Tables" in the navigation pane. I have to make sure that I did not minimize this category by using the expand/minimize button. If i do so, the table cannot be selected.

    Does this make anything clear?

    So my second question is, is there an action that opens/expands/unfolds the object categories in the navigation pane?

  6. #6
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    In the case of minimizing, just use Restore.
    Example:

    DoCmd.SelectObject acForm, Me.Name, False
    DoCmd.Restore

  7. #7
    Toasty is offline Novice
    Windows Vista Access 2007
    Join Date
    Jun 2014
    Location
    The Netherlands
    Posts
    18
    Thank you for the answer, but unfortunately I think we don't understand each other. I always minimise the categories in my Navigation Pane. There you have the option to minimize the tables to take a look at the queries or the other way around. That is my question. I think I just have to make sure that the categories are open.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 03-28-2014, 11:28 AM
  2. Replies: 6
    Last Post: 10-30-2013, 02:47 PM
  3. Replies: 2
    Last Post: 04-21-2013, 08:03 AM
  4. Replies: 5
    Last Post: 12-18-2012, 02:37 PM
  5. Navigation Pane Help Please...
    By Kristena in forum Programming
    Replies: 2
    Last Post: 01-13-2012, 03:03 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums