Navigation Pane

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Timothy Stinson - 13 Jan 2008 16:12 GMT

I read that you can minimize tha navigation pane by selecting F11, but is
there a way when an object such as a query is opened the navigation pane auto
hides?

Reply to this Message

Brendan Reynolds - 14 Jan 2008 08:18 GMT

>I read that you can minimize tha navigation pane by selecting F11, but is
> there a way when an object such as a query is opened the navigation pane
> auto
> hides?

I'm not aware of any way to do this if the query is opened using the
out-of-the-box Access UI. You could certainly do it if you created your own
form to collapse the Navigation Pane and then open the query, here's an
example ...

Private Sub cmdTest_Click()

DoCmd.SelectObject acForm, Me.Name, True
DoCmd.Minimize
DoCmd.OpenQuery "qryTest"

End Sub

Signature

Brendan Reynolds

Reply to this Message