run query on close

[agorman]

Hi,

I have a update query (to clear any selected tags) which I would like to have automatically run when I exit the database. Is there a way to do this.

At the moment I manually run the query from a form button before I close the db, but sometimes forget to do it.

Regards

Adrian

 

[Mike375]

You could attach a macro or code to a button or label to run the query then Quit.

Would it be suitable for the query to be run at start up. If so, made macro can call it Autoexec and in the macro have OpenQuery action. A macro called Autoexec will run when the data base is opened.

 

[Rich]

You could also use the Unload Event of a hidden form

 

[agorman]

Hi Mike,

I have been running the query via a button and then quitting.

I never thought of autoexec'ing it at startup - that makes it easier to do.

Thanks for that

Adrian

 

[THAWK]

Re: run query on close AUTOEXEC

Hiya,

Is there a similar macro to autoexec that can be run on close?