Printing Reports Automatically

[jesusoneez]

I want specific reports to be printed automatically at 4:00pm every day. Is there a nice easy way of doing this? Also, can the same technique be used for automatically importing data from a text file at 3:00pm?

If it takes a little coding, I'm not afraid to give it a whirl.

)

Regards,

 

[Atomic Shrimp]

You can do this quite easily with a macro and Windows task scheduler (or any other scheduling utility).

have a look at: http://www.access-programmers.co.uk/ubb/Forum5/HTML/000509.html

Mike

 

[kdevitt]

If you don't want to use macros, set up a form, and apply an [On Timer] event to it. Then have the event check what time it is, and if the time is 4pm get it to print the report.

EG

If Format(Time(), "hh") = 16 Then
docmd.openreport "ReportName",acNormal,"",""
else
exit sub

You can also apply the same technique to import a file.

The only downside is that you have to have this form open at all times, but I find it much more dynamic than Macros and Schedulers.

Ken

 

[Atomic Shrimp]

Kdevitt, what have you got your timer interval set up as?

If you set it for less than an hour, won't the timer event occur twice (or more) while the hour is "16" and you get the report twice.
If you set it for more than an hour (actually I'm not sure if this is possible - that's a lot of milliseconds), the timer event might not happen at all while the hour is "16" and you get no report at all...

Mike

[This message has been edited by Mike Gurman (edited 01-23-2001).]

 

[St. Ungland]

how do you set this up to include the day as well? I've had a go but it wants Then or Go To, but that would make the program ignore the next section about the time, help please!