Exit Procedure

[Guest]

Hi there,

I was just wondering if there was an exit procedure that runs when Access
closes. Something like the autoexec macro when the DB opens.

I'd like to be able to update a table with time stamp regardless of how the
user exits the application and was wondering if this was possible.

Thanks for your assistance!!

 

[Rick Brandt]

Hi there,

I was just wondering if there was an exit procedure that runs when
Access closes. Something like the autoexec macro when the DB opens.

I'd like to be able to update a table with time stamp regardless of
how the user exits the application and was wondering if this was
possible.

Thanks for your assistance!!

Use the close event of a form that is always open. If you don't already
have one that is always open create a hidden form to open at startup
specifically for this reason. When the app (or Access) is closed the close
event for that form will fire.

 

[Guest]

Thanks Rick!

I'll give that a shot. I thought there might be a way to do this other than
creating a hidden form but I couldn't think of anything.

Thanks again.