[AccessD] Interrupting processing

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Wed Oct 1 19:16:26 CDT 2003


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20031001/b7e0e0da/attachment-0001.html>


More information about the AccessD mailing list