[AccessD] Interrupting processing

Just put in a Global boolean variable, and check it in your processes (If
MyBool=True then AskToCancel).  Put a DoEvents in that process, and then
have your 'hotkey' set that variable to true.  That should do the trick.
 
Drew

-----Original Message-----
From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com]
Sent: Wednesday, October 01, 2003 1:37 PM
To: AccessD at databaseadvisors.com
Subject: [AccessD] Interrupting processing


Dear List:
 
I have an application with a lot of reports that take a considerable time to
run.  I always put a couple of text boxes on the calling form saying
"Processing record: xxxxx of yyyyy" and update it so the user knows there's
something going on and how much longer it will be before the report comes
up.
 
What I would like to do is to have a hotkey - probably the ESCape key -
which would interrupt the processing, pop up a message box saying
"Processing Interrupted.  Continue? (Yes/No)" and if the user elects to
continue have the code pick up where it was interrupted. Is this possible?
 
MTIA,
 
Rocky Smolin
Beach Access Software
 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20031001/eff244fd/attachment-0001.html>