Need some twitting on my code!

[ct2013]

hi there,

I use the following code in my database:

DoCmd.ShowToolbar "Ribbon", acToolbarNo
DoCmd.ShowToolbar "Menu Bar", acToolbarNo

DoCmd.NavigateTo "acNavigationCategoryObjectType"
DoCmd.RunCommand acCmdWindowHide

I have an admin form which does this:

DoCmd.ShowToolbar "Ribbon", acToolbarYes
DoCmd.ShowToolbar "Menu Bar", acToolbarYes

DoCmd.NavigateTo "acNavigationCategoryObjectType"
DoCmd.RunCommand acCmdWindowUnhide

Unfortunally i have searched all over about the runtime error 2406 - Cant unhide the navigation pane because it seems like a bug in microsoft, that since it is not open it cant unhide.


Desperate for a solution even if it means redoing some coding or adding stuff.



Many thanks in advance

 

[JHB]

Have you tried the below line for unhiding:

DoCmd.SelectObject acTable, , True