T
Tony_VBACoder
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.
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.