#ACCESS HIDE NAVIGATION PANE CODE#

I don't think you'll run into this situation much but YMMV. It won't do anything because tblEmployee is the active object name and it is also the selected item in the Nav Pane.

You open tblEmployee from the Nav Pane and it becomes the active object, then you run this routine to hide the Nav Pane.

I can't think of a good reason why you'd be hiding the Nav Pane in this instance.

The Nav Pane is open but no other objects are open.

In some cases this would cause the active form to close.

I found that the code suggested in other examples would fail if a search filter was currently set in the navigation pane. Navigation Pane but no other object if I use the above code?Д«y holding the Application.CurrentObjectName value before setting focus to the Nav Pane,ДЄnd then comparing that value to Application.CurrentObjectName after DoCmd.NavigateTo ('acNavigationCategoryObjectType'), you can tell if the Nav Pane can be closed. How can I determine if the Navigation Pane is currently open so that Or how can I make sure that I close the Navigation Pane but no other object if I use the above code? My question is: How can I determine if the Navigation Pane is currently open so that I know I have to close it. It does not return an error if there is no Navigation Pane to navigate to. Is always executed and does not return anything. The line DoCmd.NavigateTo 'acNavigationCategoryObjectType' To be sure the user does not see the pane I want to hide it but if it is already hidden then there is nothing to hide but the above command just hides my form and that is not what I want. This may happen if a warning message about data import appears and the user clicks cancel. I use DoCmd.TransferDatabase in my code and when this is executed the Navigation Pane is sometimes opened. DoCmd.NavigateTo 'acNavigationCategoryObjectType'Д«ut the problem is that if the Navigation Pane is already closed then the acCmdWindowHide will just hide any other object (i.e. The following code to close the Access Navigation Pane works.

#ACCESS HIDE NAVIGATION PANE CODE#

Access hide navigation pane