macros

[Onslaughtdave]

Hi,

Is there a way to trigger a macro whenever a query is run?

so eg, when any query is run the macro fires and does something...

thanks,

dave

 

[GingerR]

you can launch the query and subsequent macro from a button (or other control) on a form. But no, a query in itself has no events that could fire anything else.

What are you trying to do? If you tell us more, maybe we can come up with a solution for you.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Onslaughtdave]

well,

im trying to use it as like a "last used" kinda thing. When they run the query it puts the date and time into a field somewhere else.

thanks,

dave