[AccessD] Fwd: Quitting Application Problem

Darren Dick D.Dick at uws.edu.au
Wed Jul 27 19:31:28 CDT 2005


Hi Jeremy
There are a number of ways.
Here's one

Have a frm call it say...frmHidden
Have it open each time your app is started. Put it in an AutoExec Macro.
(Lemme know if you are unsure what an AutoExec Macro is) 

But have the macro open the form 'hidden' - IE not visible to anyone at
all.
In the On Unload or OnClose of that hidden form have something like...

If msgbox ("Are you sure you want to close Jeremy's way cool application
completely?",vbquestion + vbyesNo, "Confirm Application Close")=vbyes
then
	'User chose yes so let 'em quit
	'Put some code to here that allows them to exit gracefully
	'IE close other forms, close reports, stop any processes etc
	docmd.quit
Else
	'User Chose no -  so do nothing
End if

The way it works is...if the whole app is going to be closed then this
hidden form will be claosed also
Sparking the OnClose or OnUnload code thus allowing them to think about
closing completely or not
Via the message box that pops up

Hope this helps

Darren




-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jeremy Toves
Sent: Thursday, July 28, 2005 10:03 AM
To: AccessD
Subject: [AccessD] Fwd: Quitting Application Problem

Let me try this again.  I just realized my original message never made
it to the group.  Help?

Thanks,
Jeremy
 


Jeremy Toves <itsame2000 at sbcglobal.net> wrote:
Date: Wed, 27 Jul 2005 13:03:00 -0700 (PDT)
From: Jeremy Toves <itsame2000 at sbcglobal.net>
Subject: Quitting Application Problem
To: AccessD <accessd at databaseadvisors.com>

I have a database that needs to complete a few processes before it is
closed.  Some of the users are closing the application by using the "x"
in the upper right corner of the Access database.  Is there a way to
disable this?  Or can a message prompt the user to complete processing
before exiting?  Any help would be appreciated.

Thanks,
Jeremy Toves
 
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list