Exiting application

  • Thread starter Thread starter Shirley
  • Start date Start date
S

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
 
Shirley said:
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
Click to expand...

Set the 'Control Box' property to No under then form properties. Min,
Max and X will not be displayed.
 
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).
 
Try open the Properties box and choosing "No" at
the 'Close Button' option. This should disable the "X"
option.
 
Back
Top