Warning message DB is about to close...

[Guest]

Using Access 2003 on Windows XP.

I have the example code from Microsoft that closes the DB if the user goes
idle for some specified period of time and this functions well. But, I would
also like to display a message that tells the user that the DB is going to
close in 60 seconds unless they click OK.

The act of clicking OK would reset the timer; if the user isn't there, then
the form containing the warning message would close itself and then the DB
would quit.

I tried setting up a separate function that is called that loops (a DO-Loop)
for 60 seconds, but the message form doesn't display completely and causes
the DB to lock up.

Does anyone know how to accomplish this? If so, please post detailed
instructions, I'm getting no where fast...

Thanks much in advance.

 

[Keith Wilby]

Using Access 2003 on Windows XP.

I have the example code from Microsoft that closes the DB if the user goes
idle for some specified period of time and this functions well. But, I
would
also like to display a message that tells the user that the DB is going to
close in 60 seconds unless they click OK.

The act of clicking OK would reset the timer; if the user isn't there,
then
the form containing the warning message would close itself and then the DB
would quit.

I tried setting up a separate function that is called that loops (a
DO-Loop)
for 60 seconds, but the message form doesn't display completely and causes
the DB to lock up.

Does anyone know how to accomplish this? If so, please post detailed
instructions, I'm getting no where fast...

Thanks much in advance.

Use the form's timer event, no need to fake it with a loop sequence.

Keith.
www.keithwilby.com