I am printing many reports from code. How can I suppress the message box
that appears when each report prints? I have DoCmd.SetWarnings and
DoCmd.Echo set to False but there is still a pop-up message box as each
report prints.
Thanks,
David
Go to Tools, Option, Edit/Find and uncheck all of the boxes in the Confirm
area. This should do it.

Signature
James Gaylord
Finder of Paths, Hunter of Prey
Ghost of the Night, Shadow of Day
The Wolf
> I am printing many reports from code. How can I suppress the message box
> that appears when each report prints? I have DoCmd.SetWarnings and
[quoted text clipped - 4 lines]
>
> David
4110 - 26 May 2006 18:56 GMT
Hi Wolf,
Per your suggestion I unchecked the three boxes but I still got the pop-up
message boxes. Could they be associated with the system or the printers
rather than Access?
Thanks,
David
> Go to Tools, Option, Edit/Find and uncheck all of the boxes in the Confirm
> area. This should do it.
[quoted text clipped - 7 lines]
> >
> > David
Cyberwolf - 26 May 2006 19:23 GMT
What exactly doe the pop-up message say?

Signature
James Gaylord
Finder of Paths, Hunter of Prey
Ghost of the Night, Shadow of Day
The Wolf
> Hi Wolf,
>
[quoted text clipped - 17 lines]
> > >
> > > David
4110 - 26 May 2006 19:36 GMT
Wolf,
Initially it says: "Now printing ReportName..." Then it changes to say
"Printing page PageNumber...". It flashes by pretty quick and it changes so
I don't have all the words but that is the way each box starts.
David
> What exactly doe the pop-up message say?
>
[quoted text clipped - 19 lines]
> > > >
> > > > David
> I am printing many reports from code. How can I suppress the message
> box that appears when each report prints? I have DoCmd.SetWarnings
> and DoCmd.Echo set to False but there is still a pop-up message box
> as each report prints.
I think this is what you're looking for:
http://www.mvps.org/access/api/api0037.htm
API: Suppress the "Printing" Dialog
It wouldn't surprise me to find that there's some registry setting that
might be used instead, but if so, I don't know what it is.

Signature
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)
Cyberwolf - 30 May 2006 15:47 GMT
I agree Dirk, but I also do not know what it is.

Signature
James Gaylord
Finder of Paths, Hunter of Prey
Ghost of the Night, Shadow of Day
The Wolf
> > I am printing many reports from code. How can I suppress the message
> > box that appears when each report prints? I have DoCmd.SetWarnings
[quoted text clipped - 8 lines]
> It wouldn't surprise me to find that there's some registry setting that
> might be used instead, but if so, I don't know what it is.