Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / May 2006

Tip: Looking for answers? Try searching our database.

Suppress messages

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
4110 - 26 May 2006 16:35 GMT
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
Cyberwolf - 26 May 2006 17:40 GMT
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
Dirk Goldgar - 28 May 2006 18:25 GMT
> 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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.