The End statement
So, your application isn't shutting down properly? You may think there is an easy way around this:
No! End is the equivalant of stopping your car by driving it into a brick wall (stolen from a DevX newsgroup years ago :o). It does NO clean up at all, it stops the process dead. This is especially bad if you are doing any form of database or hardware access.
"What is likely to cause my application to stay running?"
An application will shut down cleanly when and only when:
- All forms are unloaded.
- All code has stopped running.
The first item is the most common cause, and there is a relatively easy way to find the culprit. Try running the following code in the Immediate/Debug window:
For Each Form In Forms: Print Form.Name: Next
This will print the name of all the currently loaded forms. If these forms shouldn't be loaded, then you need to track down where is loading them. Any code that references the user interface of a form will cause it to be loaded and left.
If you are going to have lots of forms open and you just want to shut them down, you can use a version of the code above:
Dim Form As Form
For Each Form In Forms
Happy endings all round...