Auto run/print report

[Robbie]

I have a report called "PICK TICKET" that I would like to setup to run every
10 minutes and print if data=True. Can this be done, please advise.

 

[krissco]

I have a report called "PICK TICKET" that I would like to setup to run every
10 minutes and print if data=True. Can this be done, please advise.

Use a form and OnTimer event. Keep the form hidden.

In the OnTimer, perform the steps needed to evaluate your condition
(data=True). If another user is going to be on the workstation that
your form is running on, make sure and use lots of DoEvents statements
(otherwise they may wonder why their computer locks up every 10
minutes).

If data=true then
docmd.openreport "Pick ticket"
end if


-Kris

 

[Robbie]

thanks for the quick response, a bit more information. The database will run
continuously on a computer that will run 24/7. Only the report designer will
see the report and have the ability alter or manually run the report. We are
hoping to have the report auto generate pick tickets to our warehouse every 5
minute for item submitted in the last 5 minutes.

 

[krissco]

thanks for the quick response, a bit more information. The database will run
continuously on a computer that will run 24/7. Only the report designer will
see the report and have the ability alter or manually run the report. We are
hoping to have the report auto generate pick tickets to our warehouse every 5
minute for item submitted in the last 5 minutes.

In that case, forget the DoEvents.