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

[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

 

[Albert D. Kallal]

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

 

[John Vinson]

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.

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.

 

[Jean]

Thanks a lot, John and Albert. I'll give the codes a try.

Jean