Is it possible to auto-print a report as soon as it displays?

  • Thread starter Thread starter Piri
  • Start date Start date
P

Piri

Access 97
I would like to be able to auto-print a report (2 copies) when it loads
in Preview.
Alternatively to print when the report closes (but I have failed trying
that one)

Any help gratefully appreciated.

Piri
 
The following will open your report in preview:
docmd.openreport "yourreport" , acpreview

the following will print your report (doesnt open in preview):
docmd.openreport "yourreport"

so you could use those two lines of code to perform the tasks you need by
sticking them in the OnOpen and OnClose events of your report.

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top