Re post again -- Is it possible to auto close a form after 10 minutes...

  • Thread starter Thread starter Jean
  • Start date Start date
J

Jean

Hi,

My previous message was deleted from the new group before I got a chance to
see any reply, if anyone posted an answer before to my previous question,
can you do it again. Much appreciated.

------------------------------------------------
I am using MS ACCESS 2000. Is it possible to set a timer the form load event
and auto close the form after 10 minutes ?

Thanks

Jean
 
Actually, you don't have to set anything in the forms on-load event.

Simply put the desired time into the forms timer event.

10 minutes * 60 seconds = 600 seconds.

The time in the "timer" event is in 1/1000th. So, just put in

600000

Then, the code in the forms on-timer event simply need to be:


DoCmd.Close acForm, Me.Name
 
Hi,

My previous message was deleted from the new group before I got a chance to
see any reply, if anyone posted an answer before to my previous question,
can you do it again. Much appreciated.
Click to expand...

It probably wasn't "deleted". Most newsreaders will not display
messages that you've already seen. It's possible that it never made it
to the newsgroup, however!

Yes; set the Timer property to 600000 (milliseconds, 600 seconds = 10
minutes); and in the form's On Timer event put

Private Sub Form_Timer()
DoCmd.Close acForm, Me.Name
End Sub

Posted and emailed, just in case your newsreader is missing posts...
please reply to the newsgroup, and apologies if you don't want private
mail.
 
Back
Top