Using buttons to hide/unhode the navigation pane

[Toasty]

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,

[burrina]

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

[Toasty]

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,

[burrina]

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?

[Toasty]

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?

[burrina]

In the case of minimizing, just use Restore.
Example:

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

[Toasty]

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.