control break to stop query

  • Thread starter Nils Pettersson
  • Start date
N

Nils Pettersson

Hi,

I'm using Access 2003.

When you run a query and you want to stop the process midway, all you have
to do is press on the keyboard control+break. And this stops the query.

Now, can this be done programmatically like docmd.stopquery "thisquery" ??

Thanks for the help I can get.
 
N

Nils Pettersson

Thanks for the reply. At least now I can be sure that it can't do it
programmatically.

Is there another way, though? When the user starts an append query and
suddenly decided that he doesn't want to append, is it too late? Especially,
since the append may take awhile with my database.

Should I start a new thread with this question?
 
D

Douglas J. Steele

Starting a new thread might be worthwhile, but realistically, if you ask
them in advance if they want to append the records and they say yes, I have
no sympathy for them! <g>
 
T

Tim Ferguson

=?Utf-8?B?TmlscyBQZXR0ZXJzc29u?=
Is there another way, though? When the user starts an append query and
suddenly decided that he doesn't want to append, is it too late?
Especially, since the append may take awhile with my database.
Click to expand...

DELETE FROM MyTable WHERE IJustAppendedIt = TRUE;



Hope that helps


Tim F
 
Top