Function onClose of database

[thad]

Hi All,

I was wondering if there was a way in VBA to fire a
function when the database closes or right before it
closes.

 

[Bruce M. Thompson]

I was wondering if there was a way in VBA to fire a

function when the database closes or right before it
closes.

If you open a form when the application starts, such as a Menu/Switchboard or
hidden form, and that form is to remain open until the application closes, then
call the function in that form's "On Unload" or "On Close" event procedure.

 

[Guest]

You are a genius. Thanks Bruce.

-----Original Message-----

If you open a form when the application starts, such as a Menu/Switchboard or
hidden form, and that form is to remain open until the application closes, then
call the function in that form's "On Unload" or "On Close" event procedure.

--
Bruce M. Thompson, Microsoft Access MVP
(e-mail address removed) (See the Access FAQ at http://www.mvps.org/access)
within the newsgroups so that all might benefit.<<


.

 

[Bruce M. Thompson]

You are a genius. Thanks Bruce.

Well, thank you for the compliment! <guffaw>