Automatically Print Reports

ExpandCollapse

Guest

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.

ExpandCollapse

Guest

On Tue, 20 Jun 2006 02:19:11 GMT, "Paul Goldman"
<paulgoldman1948@hotmail.com> wrote:
>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:

Share This Page

Hi all, I have read a lot of cases and the answers to the same question I have asked but here my situation is way different and complex from the rest. I'll explain little here which might seem a lot or maybe it is....but preferably I would like if someone interested could personally inbox and we...

About Us

Our community has been around for many years and pride ourselves on offering unbiased, critical discussion among people of all different backgrounds. We are working every day to make sure our community is one of the best.

Like us on Facebook

Support SPN

The management works very hard to make sure the community is running the best software, best designs, and all the other bells and whistles. We'd really appreciate your support!