Form Timer

[brsawvel]

Hello,

I have a welcome screen (form) that I would like to open automatically when I open the database, but then I would also like that form to close after three seconds and for another form to open. I know someone here has done it because I've seen it before in the sample database forum, but now I can't seem to find it again.

 

[KenHigg]

Set the timer in the forms property sheet to 3000 and then put 'docmd.close' in the timer event.

 

[missinglinq]

I assume you know to go toi Tools - Startup and set your "welcome screen" to open when your database opens; place it in the "Display Form/Page" box. Then use this code:

Private Sub Form_Load()
  TimerInterval = 4000 '1000 per 1 second
End Sub

Private Sub Form_Timer()
   DoCmd.OpenForm "[B][I]NextFormToOpen[/I][/B]"
   DoCmd.Close acForm, "[B][I]YourWelcomeScreen[/I][/B]"
End Sub

Good Luck!

Linq