Access Macro Builder

A really easy addition to any Microsoft Access database application is a Display Form, or what is commonly referred to as a Splash Screen that opens automatically when the database is opened. A Splash Screen is what appears when you open almost any application, for example, Microsoft Word.

  1. Open your database and create a new, blank form
  2. Save the form as frmSplash
  3. Add labels and graphics etc to your form using the relevant controls

Set the properties of the form as follows:

  1. Format Tab
    1. Default View: Single Form
    2. Auto Center: Yes
    3. Border Style:
  2. Other Tab
    1. Pop Up: Yes

To implement your Splash Screen:

  1. Select File ยป Options
  2. Select the Current Database section
  3. Select frmSplash from the Display Form dropdown.
  4. Add an Application Title while you are at it
  5. Click the OK button

Close and re-open your database to see your Splash Screen in action!

To get your Splash Screen to close automatically after elapsed time:

  1. Activate the Event tab of the property sheet for frmSplash
  2. Enter a value of 3000 for the Timer Interval
  3. Click in the On Timer event and click on the 3 dots on the right & select the Macro Builder option
  1. The Macro Tools Design tab will now open
  2. Click in the Add New Action dropdown & select the CloseWindow option
  3. Set the object Type to Form
  4. Select frmSplash from the Object Name
  5. and set the Save option to No
  6. Save
  7. Close

Of course, if you have a menu for your application then you can adapt the above process so that the Splash Screen is closed and your menu is opened.

For another stylish option, read the post Add an Application Icon to your Access database application

By MisterFoxOnline

CAT Educator

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.