Automatically Print Reports

[Paul Goldman]

I would like to have a report automatically printed at midnight every night.
I have created a report that generates a report for records generated that
day. I would like to create an .mde file and then would like to schedule the
mde file to run at midnight using the Windows Task Manager.

My problem is I'm really rusty with Access (2003) and don't remember how to
do it. Would some please let me know EXACTLY how I would go from the report
(which is already created an working), to having it automatically print when
I launch the .mde file.

Thanks.

 

[John Vinson]

I would like to have a report automatically printed at midnight every night.
I have created a report that generates a report for records generated that
day. I would like to create an .mde file and then would like to schedule the
mde file to run at midnight using the Windows Task Manager.

My problem is I'm really rusty with Access (2003) and don't remember how to
do it. Would some please let me know EXACTLY how I would go from the report
(which is already created an working), to having it automatically print when
I launch the .mde file.

Create a macro, RunRpt say, with just one line - use the macro wizard
to print the report.

In the command line on the Task Manager, use the /x command to execute
the macro:

"C:\Program Files\Office\Office11\msaccess.exe" "K:\SomePath\your.mdb"
/x RunRpt

all on one line of course.

John W. Vinson[MVP]

 

[John Vinson]

I would like to have a report automatically printed at midnight every night.
I have created a report that generates a report for records generated that
day. I would like to create an .mde file and then would like to schedule the
mde file to run at midnight using the Windows Task Manager.

My problem is I'm really rusty with Access (2003) and don't remember how to
do it. Would some please let me know EXACTLY how I would go from the report
(which is already created an working), to having it automatically print when
I launch the .mde file.

Create a macro, RunRpt say, with just one line - use the macro wizard
to print the report.

In the command line on the Task Manager, use the /x command to execute
the macro:

"C:\Program Files\Office\Office11\msaccess.exe" "K:\SomePath\your.mdb"
/x RunRpt

all on one line of course.

John W. Vinson[MVP]