[AccessD] Hiding the Navigation Pane in Access 2007+

Charlotte Foust charlotte.foust at gmail.com
Wed Aug 29 09:21:55 CDT 2012


Arthur, it's the same code we used to hide the database window in earlier
versions.  Works the same way too.

Charlotte

On Wed, Aug 29, 2012 at 6:16 AM, Arthur Fuller <fuller.artful at gmail.com>wrote:

> Ha ha ha! I whipped up a little test app to try it out, containing nothing
> but a form. The code you supplied bombed because there was no table to
> select LOL. So I created a table and re-ran the test form, and it worked
> like a charm. Then I selected Queries in the nav pane and the code still
> worked fine. So, in the real world, apps will have at least one table, so
> this will always work. LOL.
>
> Arthur
>
> On Wed, Aug 29, 2012 at 9:04 AM, Arthur Fuller <fuller.artful at gmail.com
> >wrote:
>
> > Thanks, Jim. I'll give that a try.
> > A.
> >
> >
> > On Wed, Aug 29, 2012 at 8:24 AM, Jim Dettman <jimdettman at verizon.net
> >wrote:
> >
> >> Arthur,
> >>
> >>  This is one way to do it:
> >>
> >> Public Sub DisplayNavPane(Optional IsVisible As Boolean = True)
> >>
> >>     DoCmd.SelectObject acTable, , True
> >>     If IsVisible = False Then DoCmd.RunCommand acCmdWindowHide
> >>
> >> End Sub
> >>
> >>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
>
>
> Website: http://www.databaseadvisors.com
>
>
>


More information about the AccessD mailing list