Results 1 to 3 of 3
  1. #1
    carstenhdk is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    May 2010
    Location
    Denmark
    Posts
    42

    Instant load of a form

    Hi




    Is it possible to make the database load a form when it is started? When I click on the database file on the desktop, I would like it to instantly open the form Frontpage. How is that possible?


    Carsten

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    In 2007 click the Office Button, Access Options, then Current Database. Select a Display Form.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    maximus's Avatar
    maximus is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    I asume that you are using Windows 7:

    Click the Microsoft Office Button (upper left corner)
    Click the Access Options button in the bottom right corner of the menu that appears
    Click the Current Database category on the left side of the Access Options dialog box
    Under Application Options section look for the option called "Display Form." Select your form name from the combo box
    Click Ok to close the Access Options
    The next time you open the database your form will load on Startup

    You can also create an AutoExec Macro:

    Set Action Of the Macro to Open Forms

    Form Name=Select the Form you Want to Open
    View=Form
    Window=Normal

    Now Name the Marco AutoExec.
    When you start open your database the AutoExec maro is run and you form will open.



    if this solves your problem mark the thread solved.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Load Record from report in form
    By rdirosato in forum Reports
    Replies: 13
    Last Post: 03-08-2010, 10:35 PM
  2. Change the text box color on form load
    By mikec in forum Programming
    Replies: 2
    Last Post: 03-01-2010, 11:47 PM
  3. On Load, form not visible
    By Bruce in forum Forms
    Replies: 15
    Last Post: 02-24-2010, 04:06 PM
  4. Program to load data
    By fsmikwen in forum Access
    Replies: 2
    Last Post: 12-10-2009, 08:36 AM
  5. Replies: 2
    Last Post: 06-17-2009, 09:50 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums