Feedback Form

Friday, February 01, 2008

Access splash screen

How to add a splash screen that closes after 10 seconds before my main form starts?

Here is one way:
1. Place the form that has the splash screen in design view and set the following properties:
Timer Interval 6000
On Timer>>>>>>Click the build button to create an event procedure. Place the following code in that procedure:
Private Sub Form_Timer()
On Error GoTo Error_Routine
' Form stays open for 10 seconds, then closes.
DoCmd.Close acForm, Me.Name
DoCmd.OpenForm "frmMainSwitchboard"
Exit Sub
MsgBox "Error# " & Err.Number & " " & Err.Description
Resume Exit_Continue
End Sub
2. Go to Startup properties on the Access Command menu tools>Startup and select the splash screen as the form hat opens at startup. Then test by restarting your application access file.

kick it on


Anonymous said...

Excellent worked first time with Access 2000 !
I tried another method before and it stopped working after a while.