AutoClose command

[jd20005]

I know that you can use a sub called AutoClose() in Microsoft Word that executes when the project closes. But this sub doesn't seem to work in Access. Does anyone know of an equivalent of AutoClose() for Access?

 

[MakeItSo]

This is not well tested, but:
You might try to put your desired function in the OnClose or OnUnload event of your main form, if you have one.
Before Access quits, it must close the db and thus all forms. This should fire the last option.

BTW: If you just want to add a compact database function there:
Since Access 2k you can
-go to Options
-General tab
-check compact on close

MakeItSo

Andreas Galambos
EDP / Technical Support Specialist
Bowne Global Solutions Wuppertal, Germany
(andreas.galambos@bowneglobal.de)
HP:

http://home.arcor.de/andygalambos