Has another "Autoexec" to execute when database cl

[timwangTM]

We know if there's macro named Autoexec in your database, Access will execute it automatically when open database. In my case, I use it to create my menu at the begining of opening database.

If there's another "Autoexec" which will be execute automatically when close database? In my case I want it to delete my menu before close database.

Or, if there's any other way to achieve my task: delete my menu when before database close? Does Access have Close event?

Any idea pls kindly share. Thanks in advance.
Tim

 

[bmacr]

Re: Has another "Autoexec" to execute when databas

This may help:

http://www.accessvba.com/showthread.php?s=&threadid=2680

 

[timwangTM]

Re: Has another "Autoexec" to execute when databas

Thanks! I get the concept and finally I build up my solution.