Access 2007: How to run form on startup.

[Bob Tourkow]

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

 

[Clint Covington \(MS\)]

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.

 

[Allen Browne]

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

 

[Bob Tourkow]

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

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