Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Thu Oct 2 15:50:50 CDT 2003
aha. got it.
Rocky
----- Original Message -----
From: Drew Wutka
To: 'Access Developers discussion and problem solving'
Sent: Thursday, October 02, 2003 1:00 PM
Subject: RE: [AccessD] Interrupting processing
It's active whenever your loop hit's a doevents statement. That's what DoEvents is for! <grin>
Drew
-----Original Message-----
From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com]
Sent: Thursday, October 02, 2003 1:36 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Interrupting processing
Drew:
Is the button Click event active while the program is in a long loop?
Rocky
----- Original Message -----
From: Drew Wutka
To: 'Access Developers discussion and problem solving'
Sent: Thursday, October 02, 2003 10:48 AM
Subject: RE: [AccessD] Interrupting processing
Quite honestly, never have used a keyboard 'breaker'. I always provide a 'cancel' or 'pause' button on a form displaying the 'current' processes.
But I guess you could have it fire on the KeyUp event, with KeyPreview turned on.
Drew
-----Original Message-----
From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com]
Sent: Wednesday, October 01, 2003 7:16 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Interrupting processing
Not sure I understand. Do I use KeyPreview to trap the keystroke of the hotkey?
Rocky
----- Original Message -----
From: Drew Wutka
To: 'Access Developers discussion and problem solving'
Sent: Wednesday, October 01, 2003 12:24 PM
Subject: RE: [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
----------------------------------------------------------------------
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--------------------------------------------------------------------------
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
------------------------------------------------------------------------------
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20031002/50f7d90a/attachment-0001.html>