Countdown Timer 1

[travis13]

Greetings-
I have setup a form that is opened during the AutoExec that I would like to display for 10 seconds, then continue with the rest of the AutoExec unless the user cancels. Is there a way to do this??

Thanks for your help!!

t

 

[chrissie1]

yes it is possible but you will need to macro's

the first will open the form
and in the load you set this

begintime = now()

set this just under the line compare database

public begintime as date

and put this in the on timer event

If Abs(DateDiff("s", begintiem, Now())) > 10 Then
DoCmd.OpenForm "form"
DoCmd.Close
End If

and set timerinterval to 100 "What a wonderfull world" - Louis armstrong

 

[travis13]

Right on.. that worked perfectly. Thank you!

 

[chrissie1]

pff not even a star "What a wonderfull world" - Louis armstrong