Hi there, I hope someone can help. I need to create an event procedure on timer that will automatically take a query, and save it in excel format to a folder on our system. It should save over the exisiting excel document each time it runs. The query name is Intro_Total_Daily_qry.
I know how to set the timer, is there a way to run this so it will action it at specific times only? E.g. 8am, 10am, 12pm, 2pm, 4pm, 6pm.
I am using MS Access 2000.
I know how to set the timer, is there a way to run this so it will action it at specific times only? E.g. 8am, 10am, 12pm, 2pm, 4pm, 6pm.
I am using MS Access 2000.