Nick,
Open the Splash Screen form in Design mode by clicking the name of your form
in the Database window, then clicking the Design button.
If the Properties window is not visible, make it visible by clicking on the
View menu, then on Properties.
Ensure that the Properties window is displaying properties for your Form
(the word "Form" will appear in the Title Bar), and not one of the controls
on it. The easiest way to do this is to click on the dark grey space below
the Form Footer while the Properties window is visible.
Click on the Event tab.
Scroll all the way down. The last two entries should read "On Timer" and
"Timer Interval".
In "Timer Interval", type "3000".
Click in the "On Timer" entry, then click on the box containing the ellipsis
(three dots).
If a "Choose Builder" window is displayed, select "Code Builder" and click
OK. If not, proceed to next step.
You should now be looking at the Visual Basic development environment, and
the following should be displayed in a window:
Private Sub Form_Timer()
End Sub
Between the two lines, add a line that says DoCmd.Close and it should now
look like this:
Private Sub Form_Timer()
DoCmd.Close
End Sub
Save your form and close it. Next time you open it, the form should close
itself after three seconds.
However, a Splash Screen that just closes itself and doesn't do anything
else is normally not very helpful. You probably want your main form to open
afterwards. To do this:
Open the Splash Screen form in Design mode, and display the Properties
Window for the form once again.
Click on the Event Tab.
Click in the "On Close" entry, then click on the box containing the ellipsis
(three dots).
If a "Choose Builder" window is displayed, select "Code Builder" and click
OK. If not, proceed to next step.
You should now be looking at the Visual Basic development environment, and
the following should be displayed in a window:
Private Sub Form_Close()
End Sub
Between the two lines, add a line so that it now looks like this (change
"MainFormName" to the name of your own form that you want the Splash Screen
to open):
Private Sub Form_Close()
DoCmd.OpenForm "MainFormName", acNormal
End Sub
Save your form and close it. Next time you open it, the form should still
close itself after three seconds, but it will also open the form you
specified.
-Michael