Closing a Database and not exiting Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steven Chicago,Illinois - 27 Jul 2007 18:58 GMT

My user would like me to switch the quit button from closing the database and
access, to just closing the database. She wants Access to stay up and allow
her to manually open up another database (avoiding the load time for access
itself). I searched for code examples, but only found mention of doing it
with no example code. Is it possible and could you show me the code?

Signature

Thanks for your Help and Patience.

Reply to this Message

Roger Carlson - 27 Jul 2007 20:15 GMT

Instead of DoCmd.Quit, use CloseCurrentDatabase

Signature

--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

> My user would like me to switch the quit button from closing the database
> and
[quoted text clipped - 4 lines]
> itself). I searched for code examples, but only found mention of doing it
> with no example code. Is it possible and could you show me the code?

Reply to this Message