how to run code when Access closes

[js]

Dear Users,

I would like to look at a table and change some data when a
user closes my frontend. How can I run some code when
Access shuts down? I dont want to use a form with a 'close'
button because the user could use also the 'X' or even Alt F4.

Thanks a lot for helping
JS

 

[B.S.Feldman]

Hi,
the common way is only to use form.
But it'l be the special form:
1. it must be load the first one or it must be loaded befor any other forms
that are common using in application are loaded.
2. it must be hidden and "popup" form. So it 'l be not visible and can be
make visible only by VBA code.
If You do so, this invisible form will be closed only before Access (or MDB)
is closing, so You can use "Unload" event for your needs.

BSF