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!!
DoCmd.SelectObject acTable, "NavigationPaneObject", True
DoCmd.RunCommand acCmdWindowHide
NavigationPaneObject = any object that is configured to be selectable within
the pane.
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
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
"Sky" wrote:
> .
>