On close or auto close in Access DB

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

XP - 20 Nov 2006 18:07 GMT

In MS-Excel you can create a function called Auto_Close that will fire when
the file is closing.

Is there an equivalent function in MS-Access? If not, is there a
work-around? Could an example please be posted?

Thanks.

Reply to this Message

Douglas J. Steele - 20 Nov 2006 18:20 GMT

No, there's no Auto_Close equivalent in Access.

The workaround is to have a form that's always open (it doesn't have to be
visible), and put your desired functionality in that form's Close event.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> In MS-Excel you can create a function called Auto_Close that will fire
> when
[quoted text clipped - 4 lines]
>
> Thanks.

Reply to this Message