Open/close Navigation Pane programatically

accesswanabe

unread,

Mar 10, 2010, 6:20:48 PM3/10/10

to

I'm using the following VBA code to establish a link from a field Access
database to a main office Access database: DoCmd.TransferDatabase acLink,
"Microsoft Access", "G:\ThePath\Transaction Database.accdb", acTable,
"tblInputNDETrans", "tblInputNDETrans"

As soon as the line starts to execute, the Navigation Pane pops open (even
though I have it turned off in "Access Options") exposing the field database
objects to who knows what. I really don't ever want this to happen for
obvious security reasons.

Is there a way to control the Navigation Panel with VBA or does someone have
a suggestion about doing something like this in another way?

Thanks!!

accesswanabe

unread,

Mar 12, 2010, 9:04:02 AM3/12/10

to

Found this solution although it is more of a work around rather than a good
solution.

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

NavigationPaneObject = any object that is configured to be selectable within
the pane.

josecatarino

unread,

May 10, 2010, 6:36:55 AM5/10/10

to

I already tried the solution you described.
Is there any way to prevent opening of Navigation Pane during execution of code ? (the same appens to me when linking to external tables)
Or ... is there any way to hide Navigation Pane with code (besides the selectable objects within the pane)
Thanks

accesswanabe wrote:

Found this solution although it is more of a work around rather than a

12-Mar-10

Found this solution although it is more of a work around rather than a good
solution.

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

NavigationPaneObject = any object that is configured to be selectable within
the pane.

"accesswanabe" wrote:

Previous Posts In This Thread:

On Wednesday, March 10, 2010 6:20 PM
accesswanabe wrote:

Open/close Navigation Pane programatically
I am using the following VBA code to establish a link from a field Access

database to a main office Access database: DoCmd.TransferDatabase acLink,
"Microsoft Access", "G:\ThePath\Transaction Database.accdb", acTable,
"tblInputNDETrans", "tblInputNDETrans"

As soon as the line starts to execute, the Navigation Pane pops open (even
though I have it turned off in "Access Options") exposing the field database

objects to who knows what. I really do not ever want this to happen for
obvious security reasons.

Is there a way to control the Navigation Panel with VBA or does someone have
a suggestion about doing something like this in another way?

Thanks!!

On Friday, March 12, 2010 9:04 AM
accesswanabe wrote:

Found this solution although it is more of a work around rather than a
Found this solution although it is more of a work around rather than a good
solution.

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

NavigationPaneObject = any object that is configured to be selectable within
the pane.

"accesswanabe" wrote:

Submitted via EggHeadCafe - Software Developer Portal of Choice
Distributed Data Grids - Share Objects Between Windows Service and ASP.NET
http://www.eggheadcafe.com/tutorials/aspnet/953ed61f-e440-4ca5-8b7a-1bb00e33db07/distributed-data-grids-.aspx

Sky

unread,

May 10, 2010, 12:37:52 PM5/10/10

to

On 5/10/2010 6:36 AM, Jose Catarino wrote:
> I already tried the solution you described.
> Is there any way to prevent opening of Navigation Pane during execution of code ? (the same appens to me when linking to external tables)
> Or ... is there any way to hide Navigation Pane with code (besides the selectable objects within the pane)
> Thanks
>

The following hide method does not require pre-configuring the
Navigation Pane to show the proper selectable objects:

DoCmd.NavigateTo "acNavigationCategoryObjectType"
DoCmd.RunCommand acCmdWindowHide

Steve

accesswanabe

unread,

Jun 7, 2010, 12:02:53 PM6/7/10

to

Thanks Steve...excellent solution!

"Sky" wrote:

> .
>

kbmo...@gmail.com

unread,

Jul 31, 2012, 8:22:19 PM7/31/12

to

This code is unreliable!!!

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

will FAIL if all of the sections of the nav "PAIN" are minimized and it will hide whatever form has the focus.

Still looking for a rock solid solution.