Banish the Access 2010 Navigation Pane

[SteveF]

Pure and simple: How do I PERMANENTLY stop the Navigation Pane from popping up when a table is imported from another Access file?



I'd really rather not have this visible to the end-users of my applications!

Steve

[TheShabz]

Does this help?
http://allenbrowne.com/ser-69.html

[SteveF]

Unfortunately, this did not work...

I did run the code & apply it to my apps, but it does not seem to have changed the behavior. After I Import a table from a remote *mdb, the Navigation Pane rears its ugly head on the left-hand side of the main window.

It really doesn't matter to me whether or not what's shown in the Pane can be changed by the user. My POV is that if you don't even see it, you won't be tempted to explore and see if it can be changed. So, we're still chasing that goal: don't even show the Nav. Pane in the first place!

Steve

[SteveF]

Got a conclusive answer to this over on Microsoft's Forum site:

Add the following code to VBA after the line in your code that adds a table to the table collection, either by importing or linking:

DoCmd.SelectObject acTable, , True
RunCommand acCmdWindowHide

It's apparently a "bug" in Access 2010.

Steve