How to start a function on windows close command [X]

[Pusher]

Hi all,
I want to start a LogMeOff function on any kind of exit - by clicking exit button I did but when I click on the x of the window I don’t know how to start that function.

Thanks a lot

 

[vbaInet]

What is the LogMeOff routine?

 

[DavidAtWork]

You need to have a hidden form that is always open and then you can call your LogMeOff function when this form unloads ie on the hidden form's Form_Unload event. This event will fire when you try to close the database using the X close button (assuming you haven't manually already closed the hidden form)
David

 

[boblarson]

You need to have a hidden form that is always open and then you can call your LogMeOff function when this form unloads ie on the hidden form's Form_Unload event. This event will fire when you try to close the database using the X close button (assuming you haven't manually already closed the hidden form)
David

What he said. (that's the way I do it)

 

[Pusher]

I have a module with a logmein and logmeoff function that gives users permissions when they login

 

[Pusher]

Thanks - i already have a hidden login form for getting a username

 

[vbaInet]

I have a module with a logmein and logmeoff function that gives users permissions when they login

Still not enough information. Can you be more descriptive.

 

[Pusher]

I imported the login forms and modules from here - http://www.access-programmers.co.uk/forums/showthread.php?t=193131 - LogMeOut is an action that gets log for exiting the db.

 

[vbaInet]

Can you explain in a sentence each what logmein and logmeoff functions do when you log in and log out. Or how you use it.

 

[Pusher]

I imported the whole thing so I can’t explain it in detail. I just know that the function logmein and out writes a user name time of login and time of logout in a specific table so I can know when and who logged in and logged out

 

[vbaInet]

Well, that's the problem - copying code without understanding what it does.

The LogMeOut function sounds like something that should be run when the db is closed, not just when any form's or report's [X] button is clicked.