Hello, beginner here.
I want an Access database to be closed as a VB form is closed. Firstly I'm not sure how to call the procedure, I thought it would come under:
Private Sub Form_Close()
However nothing happens when I close the form, so I assume that is wrong.
Secondly, I want the Access application as well as the database to close when I call this procedure. At the moment I have:
Private Sub Form_Close()
objAccess.CloseCurrentDatabase
Set objAccess = Nothing
End Sub
But this only closes the database and leaves the application running.
Any help would be appreciated.
Lisette
I want an Access database to be closed as a VB form is closed. Firstly I'm not sure how to call the procedure, I thought it would come under:
Private Sub Form_Close()
However nothing happens when I close the form, so I assume that is wrong.
Secondly, I want the Access application as well as the database to close when I call this procedure. At the moment I have:
Private Sub Form_Close()
objAccess.CloseCurrentDatabase
Set objAccess = Nothing
End Sub
But this only closes the database and leaves the application running.
Any help would be appreciated.
Lisette