I have a custom Access database (not created by me) that in Access 2003
automatically ran a form ("Central Hub") on startup. The custom screens
require the full screen width, which means that with the new Navigation Bar
in place (even minimized) I lose the far right side of my screens. (The
minimized Nav Bar "pushes" the screen to the right about 1/2 inch.) I
understsand I can have the Nav Bar not appear on startup (I normally don't
need it when running the custom DB), but if I can't get the Central Hub form
to automatically appear when I open the DB, then I must have the Nav Bar to
select the form.

So I have two questions:

1. Can I get the Central Hub form to appear automatically on startup? If I
can, then I can tell the Nav Bar to not appear, giving me thte full screen
width.

-or-

2. After the DB is opened (and I have manually selected the Central Hub
form), can I close - not just minimize - the Nav Bar, which would give me the
full screen width?

Thanks. Bob

you can hide the nav pane just like you did the old dbc.

http://www.mvps.org/access/general/gen0031.htm

You can set the central form as the startup form in the Office button |
Access Options and click on the current database tab.


"Bob Tourkow" <(E-Mail Removed)> wrote in message
news:7EDA74CB-9053-43D5-B291-(E-Mail Removed)...
>I have a custom Access database (not created by me) that in Access 2003
> automatically ran a form ("Central Hub") on startup. The custom screens
> require the full screen width, which means that with the new Navigation
> Bar
> in place (even minimized) I lose the far right side of my screens. (The
> minimized Nav Bar "pushes" the screen to the right about 1/2 inch.) I
> understsand I can have the Nav Bar not appear on startup (I normally don't
> need it when running the custom DB), but if I can't get the Central Hub
> form
> to automatically appear when I open the DB, then I must have the Nav Bar
> to
> select the form.
>
> So I have two questions:
>
> 1. Can I get the Central Hub form to appear automatically on startup? If
> I
> can, then I can tell the Nav Bar to not appear, giving me thte full screen
> width.
>
> -or-
>
> 2. After the DB is opened (and I have manually selected the Central Hub
> form), can I close - not just minimize - the Nav Bar, which would give me
> the
> full screen width?
>
> Thanks. Bob

A1: You can set the startup form in Access 2007 through:
Microsoft Office button (top left)
Access Options (lower border of dialog)
Current Database tab
Display Form

A2: You can programmatically hide the Nav Pane in A2007 with:
DoCmd.SelectObject acForm, , True
RunCommand acCmdWindowHide

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Bob Tourkow" <(E-Mail Removed)> wrote in message
news:7EDA74CB-9053-43D5-B291-(E-Mail Removed)...
>I have a custom Access database (not created by me) that in Access 2003
> automatically ran a form ("Central Hub") on startup. The custom screens
> require the full screen width, which means that with the new Navigation
> Bar
> in place (even minimized) I lose the far right side of my screens. (The
> minimized Nav Bar "pushes" the screen to the right about 1/2 inch.) I
> understsand I can have the Nav Bar not appear on startup (I normally don't
> need it when running the custom DB), but if I can't get the Central Hub
> form
> to automatically appear when I open the DB, then I must have the Nav Bar
> to
> select the form.
>
> So I have two questions:
>
> 1. Can I get the Central Hub form to appear automatically on startup? If
> I
> can, then I can tell the Nav Bar to not appear, giving me thte full screen
> width.
>
> -or-
>
> 2. After the DB is opened (and I have manually selected the Central Hub
> form), can I close - not just minimize - the Nav Bar, which would give me
> the
> full screen width?
>
> Thanks. Bob

That seems to have done it. Thanks very much, Clint.

- Bob
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

"Clint Covington (MS)" wrote:

> you can hide the nav pane just like you did the old dbc.
>
> http://www.mvps.org/access/general/gen0031.htm
>
> You can set the central form as the startup form in the Office button |
> Access Options and click on the current database tab.
>
>
> "Bob Tourkow" <(E-Mail Removed)> wrote in message
> news:7EDA74CB-9053-43D5-B291-(E-Mail Removed)...
> >I have a custom Access database (not created by me) that in Access 2003
> > automatically ran a form ("Central Hub") on startup. The custom screens
> > require the full screen width, which means that with the new Navigation
> > Bar
> > in place (even minimized) I lose the far right side of my screens. (The
> > minimized Nav Bar "pushes" the screen to the right about 1/2 inch.) I
> > understsand I can have the Nav Bar not appear on startup (I normally don't
> > need it when running the custom DB), but if I can't get the Central Hub
> > form
> > to automatically appear when I open the DB, then I must have the Nav Bar
> > to
> > select the form.
> >
> > So I have two questions:
> >
> > 1. Can I get the Central Hub form to appear automatically on startup? If
> > I
> > can, then I can tell the Nav Bar to not appear, giving me thte full screen
> > width.
> >
> > -or-
> >
> > 2. After the DB is opened (and I have manually selected the Central Hub
> > form), can I close - not just minimize - the Nav Bar, which would give me
> > the
> > full screen width?
> >
> > Thanks. Bob
>
>
>