Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Access 2007: How to run form on startup.

Discussion in 'Information Technology' started by Bob Tourkow, Jul 28, 2006.

  1. Bob Tourkow

    Bob Tourkow
    Expand Collapse
    Guest

    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
     
  2. Loading...


  3. Clint Covington \(MS\)

    Clint Covington \(MS\)
    Expand Collapse
    Guest

    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" <BobTourkow@discussions.microsoft.com> wrote in message
    news:7EDA74CB-9053-43D5-B291-3C71F5119DA1@microsoft.com...
    >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
     
  4. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    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" <BobTourkow@discussions.microsoft.com> wrote in message
    news:7EDA74CB-9053-43D5-B291-3C71F5119DA1@microsoft.com...
    >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
     
  5. Bob Tourkow

    Bob Tourkow
    Expand Collapse
    Guest

    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" <BobTourkow@discussions.microsoft.com> wrote in message
    > news:7EDA74CB-9053-43D5-B291-3C71F5119DA1@microsoft.com...
    > >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

    >
    >
    >
     

Share This Page