ACCESS FEED: Re: [MS_AccessPros] User clicks the X (close) button on a form in the upper-right hand corner and it closes.

Rabu, 10 Desember 2014

Re: [MS_AccessPros] User clicks the X (close) button on a form in the upper-right hand corner and it closes.

Liz-

No. To emulate an "On Quit" event, I have the app open a hidden form that has Close and Unload events. I use a global variable to indicate whether the form is being closed by code in the app (in the main switchboard exit code, for example) or not. If the variable isn't set, the Close or Unload events can do some warning messages and clean-up, but it can't keep the Quit from finishing.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On Dec 10, 2014, at 4:43 PM, Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

I'm curious. Is there an event for application.quit?

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Wednesday, December 10, 2014 8:29 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] User clicks the X (close) button on a form in the upper-right hand corner and it closes.

Norbert-

What is it you're trying to accomplish?

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On Dec 10, 2014, at 1:39 PM, drnorbert@msn.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Can a warning message be created when ONLY the user clicks the X(Close) button on a form in 2010/2013 Access?

Thanks

Norbert

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

__._,_.___

Posted by: John Viescas <johnv@msn.com>

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (4)

Visit Your Group