Which events to use for splashscreen at Startup A97

  • Thread starter Thread starter Robert Harrison
  • Start date Start date
R

Robert Harrison

What Events do I use to Accomplish this?
This is what I want to happen:

Splashscreen (form) Opens (Startup Option, this works)
Check for Connection to Back-end Database (works)
If No Connections, Prompt User to Reconnect (I'm using the Splashscreen Form
Now, works)
Show Splashscreen for a few seconds (Works)
Hide or Close Splashscreen (This is where it goes bad, the connection codes
either gets retriggered if I Open the Switchboard First, or I can't open the
switchboard because I close the Splashscreen.
Open Switchboard Form

I've tried Actiivate, Open, etc. but it always retriggers the code for
connecting the database again. I'm putting the code on the splashscreen
form, maybe it should be somewhere else?

All the rest of the code works.
 
I'm not sure what your code is to accomplish your tasks
but the Timer code should go something like this:

Private Sub Form_Timer()

If fRefreshLinks Then
DoCmd.OpenForm "frmLogin"
DoCmd.Close acForm, "frmSplash"
Else
MsgBox gstrErrorDefault 'error message
DoCmd.Quit
End If

End Sub

Sandy
 
Back
Top