|
Subject:
|
Autoexec Upon Close
|
|
Posted By:
|
SerranoG
|
Post Date:
|
5/16/2006 2:32:16 PM
|
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
|
|
Reply By:
|
SerranoG
|
Reply Date:
|
5/16/2006 3:20:33 PM
|
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
|
|
Reply By:
|
echovue
|
Reply Date:
|
5/16/2006 3:23:11 PM
|
Hi Greg,
I have been looking for way, as that could be useful in the future.
Thanks for sharing,
Mike
Mike
EchoVue.com
|
