How do i set up a macro that will repeat automatically?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to display an Access query on a big screen and have it automatically
update the query every 5-10 minutes.
 
Mike,

I would suggest using a continuous view form bound to the query, and
show your data here. You can set the Timer Interval property to the
required value (milliseconds, so you would enter 300000 for 5 minutes).
And then make a macro with the Requery action (leave the Control Name
agrument blank), and assign the macro on the On Timer event property of
the form.
 
Back
Top