unable to quit microsoft access without MsgBox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have developed a module in MS access 97, which is called from a form.
Everything seems to work fine, but when I close the database, I am not able
to quit Access. Access is minimized, but the database is closed.

If I add a MsgBox instruction in the module, everything works ok. Without
the MSgBox instruction, I have the above described problem.


ps all recordsets are closed via the Close method
 
DoCmd.Close just closes the current form. DoCmd.Quit will close Access. You
could make a button on your form and make DoCmd.Quit the last line on its
Click event.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code won't quit 3
Excel Providing user message when RED X clicked & properly closing application. 2
Disbling Close button for Access 2
Run time error - (-2147467529 (80004005)) 1
If Statement with MsgBox 7
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Database Bloating 1
Quit Access 2

Back
Top