Exiting application

[Shirley]

I am strugling here...I created a log activity table to
record the time when users log in and log out. The
application runs well if user click the control button I
built to log out. But some people just click the "X" on
the top right to close the application. In this case, my
application will not be able to record the time when the
user closes the application. how can I resolve this
problem?

Thanks,

Shirley

 

[John Spencer (MVP)]

Create a form and open it hidden.

When the user tries to quit the application, the form must close.

In the form's on close event, run SQL or other VBA code to populate the record
with the desired value(s).

 

[Kat3n98]

Try open the Properties box and choosing "No" at
the 'Close Button' option. This should disable the "X"
option.