Cancel Query

[StefanSch]

I have a form with a command button which starts a time-consuming make-table query (about 10 minutes). Is there a way to give the user the possibility to stop an ongoing query?

When running the make-table query, MS Access pops up a form which says "please wait.......". On this pop up form I would like to include a button "Cancel" which would stop the make-table query.

I am happy about any ideas.

Thank you. Stefan

 

[AlanS]

You can stop a query by pressing Ctrl-Break, but this can be messy (depending on the context).

You may also want to change the command button's Click event procedure, so that a MsgBox is displayed, warning the user that the query is lengthy and offerring the user several ways to respond (Yes/No, OK/Cancel, etc.), and then only actually launching the query if the user clicks the correct button.