G
Guest
Hello I am working with Access 2003, how I would set up a method to run a
report at a particular time and date.
report at a particular time and date.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
AlCamp
Dexter,
You can use the Windows Task Manager to start an Access application.
See "command-line options" in Help. When Task Manager starts Access, you
can use the command-line (/m) option to run a specific macro.
hth
Al Camp
You can use the Windows Task Manager to start an Access application.
See "command-line options" in Help. When Task Manager starts Access, you
can use the command-line (/m) option to run a specific macro.
hth
Al Camp
G
Guest
The best way I have found to do this is to create an form that has a timer on
it. The timer should fire every minute. Check the current time against the
time you want the report to run. If they match print the report using code.
Hope this helps
Dale
it. The timer should fire every minute. Check the current time against the
time you want the report to run. If they match print the report using code.
Hope this helps
Dale
G
Guest
Hi Dkalsow, thank you for your assistance. I set up a test database by
putting the Timer Interval to 1000 and On Timer Macro which is set to
Printout. I am currently receiving an Information message stating "This
action can't be carried out while processing a form or report event. A macro
specified as the OnOpen, OnFormat, OnRetreat, OnPage, or OnPrint property
setting contains an invalid action for the property."
Please instruct me on a solution to the situation.
putting the Timer Interval to 1000 and On Timer Macro which is set to
Printout. I am currently receiving an Information message stating "This
action can't be carried out while processing a form or report event. A macro
specified as the OnOpen, OnFormat, OnRetreat, OnPage, or OnPrint property
setting contains an invalid action for the property."
Please instruct me on a solution to the situation.
A
agrogers
I have a feeling this can occur when the timer triggers at a moment when
there is Modal form open. Closing the modal form for me is when the
error occurs. Not sure what can be done about it though. Maybe trying
to pause the timer when the form opens and starting it when it closes.
or not opening the form as a modal one.
there is Modal form open. Closing the modal form for me is when the
error occurs. Not sure what can be done about it though. Maybe trying
to pause the timer when the form opens and starting it when it closes.
or not opening the form as a modal one.
*Hi Dkalsow, thank you for your assistance. I set up a test database
by
putting the Timer Interval to 1000 and On Timer Macro which is set
to
Printout. I am currently receiving an Information message stating
"This
action can't be carried out while processing a form or report event.
A macro
specified as the OnOpen, OnFormat, OnRetreat, OnPage, or OnPrint
property
setting contains an invalid action for the property."
Please instruct me on a solution to the situation.
:
[vbcol=seagreen]The best way I have found to do this is to create an form that has a timer on
it. The timer should fire every minute. Check the current time against the
time you want the report to run. If they match print the report using code.
Hope this helps
Dale
:
*