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!!

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:

> 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!!

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 goo
solution

DoCmd.SelectObject acTable, "NavigationPaneObject", Tru
DoCmd.RunCommand acCmdWindowHid

NavigationPaneObject = any object that is configured to be selectable withi
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 Acces
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 (eve
though I have it turned off in "Access Options") exposing the field databas
objects to who knows what. I really do not ever want this to happen fo
obvious security reasons

Is there a way to control the Navigation Panel with VBA or does someone hav
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 goo
solution

DoCmd.SelectObject acTable, "NavigationPaneObject", Tru
DoCmd.RunCommand acCmdWindowHid

NavigationPaneObject = any object that is configured to be selectable withi
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...ta-grids-.aspx

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

Thanks Steve...excellent solution!

"Sky" wrote:

> 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
> .
>

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.