How to stop a process?

[mmogul]

I have a process that loads about 100 spreadsheets into a database. The user enters a few parameters prior to initiating the load. If they start the process and realize they made an error with one of the parameters, they would like to stop the upload process.

How do you set this up where the user would click a button to stop the process, get a confirming message, and then cancel or continue the process?

Thanks.

 

[PHV]

What about the Ctrl-Pause key combination ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[genomon]

You will probably want to look into transactions & rollback if you interrupt an upload.

"Don't be irreplaceable. If you can't be replaced, you can't be promoted."

 

[MichaelRed]

assuming the process is a series of VBA statements (e.g. TransferSpreadsheet(args)

Then a simple DoEvents between calls would interrupt the process sufficiently to allow <crl>-<Break> to at least stop the code.



MichaelRed

 

[mmogul]

Thanks for everyone's input