Create a Cancel Button to Halt an operation
From: Tony_VBACoder (anonymous_at_discussions.microsoft.com)
Date: 07/28/04
- Next message: Rick B: "Re: Required Field"
- Previous message: Dirk Goldgar: "Re: syntax to refer to a control on a form's subform?"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 28 Jul 2004 08:33:35 -0700
With Access 2000 or 2002, I am looking for a method to
create a Cancel button on some form, that when clicked,
would stop the execution of a Query.
I have an Entry Form where a user can enter certain
criteria and when the user clicks the OK button, a bunch
of queries run (some are Update Queries and others are
Delete Queries). While the process is running, I load
a "Please Wait" form that displays the progress to the
user. This is the form that I would like to add
a "Cancel" button, where when pressed, will halt the
execution of the Query that is being run. It appears that
when I issue a SQL statement via the DoCmd.RunSQL "DELETE
* FROM tbl1" or issue the DoCmd.OpenQuery "qryDelete", my
code halts until the query has finished, then the next
line of code runs.
- Next message: Rick B: "Re: Required Field"
- Previous message: Dirk Goldgar: "Re: syntax to refer to a control on a form's subform?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
