Link to home
Start Free TrialLog in
Avatar of AlexPonnath
AlexPonnathFlag for United States of America

asked on

How can i exit a Loop we nottom Click Event...

I have a Program which imports data into sql server DB's. The tool works fine but i would like to add an
option for the user to abort / stop the import process once he clicks on a bottom. Right now the only
way to do this is to close or kill the app ?

Any idea how this can be done..
Avatar of doobdave
doobdave

What is the problem exactly?
Does your button not respond because of the import operation is in progress?

If so then the problem is to do with threading, I can provide links to a couple of very useful articles.

Please clarify your prob.
ASKER CERTIFIED SOLUTION
Avatar of nachiket
nachiket

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
put a command button called abort

Private Sub abort_click()
'Close the connection
conn.close
End Sub