Running code when access shut down with cross

[Dixie]

My application runs some temporary file clean up code as an onClick event
when users click the exit button. My problem is that some users don't exit
properly and simply click the cross on the top right corner of the window it
is running in.

Can I run the code somehow when that happens? If so, how?

TIA
dixie

[Bob Quintal]

"Dixie" <di***@dogmail. com> wrote in
news:12******** *****@corp.supe rnews.com:

My application runs some temporary file clean up code as an
onClick event when users click the exit button. My problem is
that some users don't exit properly and simply click the cross
on the top right corner of the window it is running in.

Can I run the code somehow when that happens? If so, how?

TIA
dixie

move the code from the On Click event of the button to the on Close
event of the form containing that button.


--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

[Dixie]

Does this mean that Access automatically closes forms before it exits?

It is quite possible that the particular form would have its visible
attribute set at false, does that matter?

dixie

"Bob Quintal" <rq******@sPAmp atico.ca> wrote in message
news:Xn******** **************@ 66.150.105.47.. .

"Dixie" <di***@dogmail. com> wrote in
news:12******** *****@corp.supe rnews.com:

My application runs some temporary file clean up code as an
onClick event when users click the exit button. My problem is
that some users don't exit properly and simply click the cross
on the top right corner of the window it is running in.

Can I run the code somehow when that happens? If so, how?

TIA
dixie

move the code from the On Click event of the button to the on Close
event of the form containing that button.


--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

[w_a_n_n_a_l_l_ -]

Access closes all forms before it closes, visible or not.

[Dixie]

Great, then that's perfect, as this form is always open, but often
invisible. Problem solved. Thankyou both.

dixie

<w_a_n_n_a_l_ l_ -@-_s_b_c_g_l_o_b_ a_l._n_e_t> wrote in message
news:kc******** ***********@new ssvr27.news.pro digy.net...

Access closes all forms before it closes, visible or not.

[Bob Quintal]

"Dixie" <di***@dogmail. com> wrote in
news:12******** *****@corp.supe rnews.com:

Does this mean that Access automatically closes forms before
it exits?
Yes!
It is quite possible that the particular form would have its
visible attribute set at false, does that matter?
Not in the least. I often use a "Welcome" form as a splash
screen, and hide it after 5 seconds. It contains clean-up code
as well as the set-up code.

dixie

"Bob Quintal" <rq******@sPAmp atico.ca> wrote in message
news:Xn******** **************@ 66.150.105.47.. .

"Dixie" <di***@dogmail. com> wrote in
news:12******** *****@corp.supe rnews.com:

My application runs some temporary file clean up code as an
onClick event when users click the exit button. My problem
is that some users don't exit properly and simply click the
cross on the top right corner of the window it is running
in.

Can I run the code somehow when that happens? If so, how?

TIA
dixie

move the code from the On Click event of the button to the on
Close event of the form containing that button.


--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com