I know that a macro named "Autoexec" will automatically run when the database is opened, but is there a way to get a macro to run automatically when the database is closed?

I'm using Access 2002 (XP). Thanks in advance.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

__________________
Greg Serrano
Michigan Dept. of Environmental Quality
Air Quality Division

Someone suggested I create a form that is opened hidden using Autoexec when the database opens. Then when the database closes, the hidden form's ON CLOSE event kicks in, running the other macro. It works!

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Hi Greg,

I have been looking for way, as that could be useful in the future.

Thanks for sharing,

Mike

Mike
EchoVue.com