Auto Running Macros

[BrianB75]

O.K., one of my databases is used to run reports on a daily basis and currently has to be done manually. What I want is to have this run on a daily basis, early in the morning so if I am not at worh the reports are sent out. I setup the following but it does not seem to work:

Using the Scheduled Tasks to open the database @ 7:00am Monday-Friday.

In the database I have a form that autoloads and on the Timer event (1000ms) runs a macro that fires off the reports. I have a condition setup on the macro of Time() = #7:05:00 AM#. The last entry on the macro closes the database after the reports run.

The problem is that the database opens but the macro never fires.

I tried testing the OnTimer property with the conditional statement in the macro and it works every time.

Any ideas?

I seached throught the forum and couldn't find anything that specifically address the issue I am having. Found a lot of other commands I can use in other places however.

Thanks in advance...

 

[Dachande]

Hello,

Can you not just abandon the On Timer event and get it to automatically send the reports out as soon as the database opens. I know that this is not ideal but its how I do it currently as it is effectively on a timer already seeing as its a scheduled task.

Either have the Form load on startup and use an On Open event or use the Austoexec macro to automatically produce the reports.

Mark

 

[BrianB75]

I had thought of that but the database is also used for other functions on some other user's PCs and I don't want the reports running multiple times.

I suppose I could create a seperate database for just those reports but I did not want to have to do this as I might have other needs for this type of functionality in the future.

Thanks though...