Running an automated Query created in MSACCESS (1 Viewer)

[utopianbl]

Hello All,

I am new here and new to Access.

I have created a query which allows me to schedule daily events. But I want to automate this. Let me explain what i am trying to do.

Every morning at 7 am I want this query to run and the output of which to be mailed to myself. All this without me having to hit any button of sorts.

I have a long shot but very inefficient answer to this - which would be - having to leave my MS ACCESS running all night with an infinite loop checking to see what the system time is. When the infinite loop equates to 7 am it runs the query. But I think this would be a massive memory guzzler and I don't like this solution. Is there something else I can do?

Thanks for you time.

Regards

 

[KeithG]

You could use the On_Timer event on a form. You can write code to check to see if the current time is 7:00 every Hour, minute, or five minutes. Use the timer interval property to set the length of the timer.