print question

  • Thread starter Thread starter Joanne
  • Start date Start date
J

Joanne

I have a form where the user can choose any of 13 reports to send to
the printer.
I used a macro to set up the commands to do the printing.
I used 'echo no" before each report's print command, yet I still get
the small dialog box "sending report to printer" for each doc being
printed. It is this quick flashing going on and is quite distracting.
Could anyone tell me how to stop this from showing to the user.
Thanks for all your time and expertise
Joanne
 
Steve
Thanks for your reply. I went to the site and the coding sure is
extensive to do this small job.
I think I could help myself some if I was able to send each doc the
user chose to a 'collection' of some sort and then send the docs to
the printer all together instead of individually. Then the dialog box
should flash only once, I am hoping.

I'm not sure how to do this, maybe you could get me started. Right now
I have a macro that does OpenReport / Print Mode when the user clicks
it, and I have this for each document. I would like to be able to
catch each click and then send the whole bunch to the printer at once.
What do you think?
Thanks muchly for your time and expertise. It is so appreciated.
Joanne
 
Joanne:

Access provides no way to group a bunch of reports into one print job so
that the dialog would only flash once. You could theoretically combine
reports as subreports of a single main report to do that, however selecting
and setting subreports at run time is not very practical.
 
Okay Steve - thanks for all of your help.
I wonder if I could do something like this in vba instead of in a
macro? or does vba lack the ability to bunch the reports also?
Thanks
 
Back
Top