How to Create a Microsoft Access Splash Screen

When Access loads we tend to see the database window. We can hide this and show
our own start up screen. This is known as a Microsoft Access Splash Screen.

Let’s get started.

Create a brand new form.

Drag a label onto it and add a caption.

 

Set any background or fore color properties you need.

Great so far.

Now bring up the form properties.

Set the following properties:

• Scroll Bars – neither
• Record Selectors – no
• Navigation Buttons – no
• Dividing Lines – no
• Auto Center – yes
• Control Box – no
• Min Max Buttons – none

Now switch to event properties.

Look for the ‘On Timer’ event.

Set the Timer Interval to 10000.

 

Click the small button on the side of the ‘On Timer’ event to bring up the code
window.

Between the Private Sub Form_Timer() and the End Sub, add the following code.

DoCmd.Close acForm, “frmStartUp”
DoCmd.OpenForm “Main Switchboard”

Your procedure should look as follows:

Private Sub Form_Timer()
DoCmd.Close acForm, “frmStartUp”
DoCmd.OpenForm “Main Switchboard”
End Sub

In the second line change “Main Switchboard” to whatever form you want to load
after the MS Access splash screen closes.

Now save the code and close the code window.

Save the form as ‘frmStartUp’.

From the ‘Tools’ menu select the ‘Startup’ option.

 

In the ‘Display Form/Page’ box select ‘frmStartUp’.

Uncheck the ‘Display Database Window’ box.

Click OK.

 

Close your database.

Now re open the database.

Your start up form – MS Access splash screen – will load and after ten seconds will close.

Your next form will then load.

Microsoft Access splash screens offer a more professional start up look to our applications. They are
not essential, but if we need them they are easy to create in Access.

Tags: