Print a report every hour automatically

Topic

New Reply

I know this has been discussed before but a search on this topic produced no results.. Sooo.. I would like to have my Access 97 database print a report every hour automatically.. Apparently the users find it hard to push a button once an hour.. Can this be done without using the windows scheduler? Thanks..

Reply | Quote

Replies

Hi Gary,

I can’t remember the upper limit on the timer function, but you could have a form open (and perhaps hidden) with a timer event triggering a print command every hour…Just a thought

Reply | Quote

Hey Mark.. I messed with that a little.. I had it printing every 10 minutes or so.. Would you know how to make it print at a certain time.. Like 9:30.. I got this code from another post but it keeps failing (Run time error 13 type mismatch.. I used this on the ON timer event and set the Time interval to run every mintue but it failed..
From what I gather it should check the time see if it’s 8:00 if it is it print the report.. Don’t know why it failed though..

If Format(Time(), “hh”) = 8 Then
docmd.openreport “ReportName”,acNormal,””,””
else
exit sub

Reply | Quote

In theory it looks just fine. I’m not sure what the quotes are after acNormal, but if you have no criteria try it without, i.e docmd.openreport “ReportName”,acNormal One other thing, if you want to print on the hour Format(Time(),”nn”) and test for 0 to print at 08:00, 09:00 etc.

Reply | Quote

Why is the Windows Scheduler not an option?

Reply | Quote

I’ve experimented with the windows scheduler and it does work well but my users are completely clueless.. The whine and complain if the have to do anything.. I made a batch file that the user needs to run to update the database to a new version and they compalin about that.. I mean it is tough to type r:system.bat and the run command.. Sorry just venting.. But to use Scheduler I would have to go to each users pc about 30 and set the appointments.. Unless there is another way?

Reply | Quote

Are you saying that each user has to run a report every hour?

At my place of employment, I have a separate PC that all it does it run jobs. I use WSH & VBScripts and put them in the scheduler. We have scripts that fire up Excel, generate some charts, and E-mail when it’s done. I haven’t done any VBScripts with Access but I’d be willing to bet that it’s possible. You could write the script to E-mail the report or better yet publish the report to a web. I don’t know all the details of your situation, so this is just my

Reply | Quote