If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Auto run/print report
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. -- kuslusr1 |
#2
|
|||
|
|||
Auto run/print report
On Aug 15, 9:00 am, Robbie wrote:
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. -- kuslusr1 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 |
#3
|
|||
|
|||
Auto run/print report
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. -- kuslusr1 "krissco" wrote: On Aug 15, 9:00 am, Robbie wrote: 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. -- kuslusr1 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 |
#4
|
|||
|
|||
Auto run/print report
On Aug 15, 10:14 am, Robbie wrote:
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. -- kuslusr1 In that case, forget the DoEvents. |
Thread Tools | |
Display Modes | |
|
|