print question

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
 
J

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
 
S

SA

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.
 
J

Joanne

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
 
Top