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