Jim Dettman
jimdettman at verizon.net
Wed Aug 29 09:35:32 CDT 2012
Well a DB would have to have at least one object and the code would need to be modified. I don't see that as a big deal. If you don't want to count on that, you can always use sendkeys and Alt/F11, which is another way to show/hide the nav pane. As Charlotte said, the nav pane is the replacement for the DBC and controlling it works the same. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller Sent: Wednesday, August 29, 2012 09:16 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Hiding the Navigation Pane in Access 2007+ 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