[AccessD] Stop That Code!

John W. Colby jcolby at ColbyConsulting.com
Sun Apr 6 18:43:49 CDT 2003


Rocky,

This may or may not be possible.  If you are running a loop that updates
records in code (using recordsets) then wrap it in transactions and add
keyboard handling to look for the escape and running a message box asking if
the user wants to abort.  If answer yes, then rollback (or don't commit) and
exit.

If you are running a query to update these same records, it isn't possible
to break in the middle.  Access simply doesn't allow that.  Even if you have
a function that is called by the query, if the user continues (which they
must) the query picks right back up where it was updating the next record.

John W. Colby
Colby Consulting
www.ColbyConsulting.com

  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Rocky Smolin -
Beach Access Software
  Sent: Sunday, April 06, 2003 1:37 PM
  To: AccessD at databaseadvisors.com
  Subject: [AccessD] Stop That Code!


  Dear List:

  I have some processes in an app which take a while to execute.  I
generally put something on the screen to show the user that progress is
being made. I'd like to give them the capability to abort the process by
pressing the ESC key.  Maybe they used data selection criteria to select 12
records and instead selected 12,000.  Or made a mistake starting a long cost
roll up or calculation which they'd like to abort.

  What's the simplest way to accomplish this?


  MTIA,

  Rocky Smolin
  Beach Access Software




----------------------------------------------------------------------------
----

Is email taking over your day? Manage your time with eMailBoss. Try it free!
http://www.eMailBoss.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030406/5881972b/attachment-0001.html>


More information about the AccessD mailing list