Connecting Tech Pros Worldwide Help | Site Map

How to turn off echo of 'print msg box' when doing docmd.openreport

  #1  
Old January 12th, 2009, 09:03 PM
Member
 
Join Date: May 2007
Posts: 103
I am using access 2000. I am running some reports using DoCmd.open 'ReportName' and after each, the box 'Printing' pops up. I am trying to turn this off as I do not want to display this message box after each report. I have tried Application.Echo = False and I still get the print message box. Is there any way to turn this off?
Thanks!
  #2  
Old January 13th, 2009, 01:35 PM
NeoPa's Avatar
Administrator
 
Join Date: Oct 2006
Location: London - UK
Posts: 15,473
Provided Answers: 57

re: How to turn off echo of 'print msg box' when doing docmd.openreport


I found this in the Insights forum (for HowTos and Articles) so I've moved it for you and bumped it.

I would help but I have never tried this, nor can I think of a helpful set of google words to use. I'll have to see if one of the other experts can help you here.
  #3  
Old January 13th, 2009, 01:42 PM
NeoPa's Avatar
Administrator
 
Join Date: Oct 2006
Location: London - UK
Posts: 15,473
Provided Answers: 57

re: How to turn off echo of 'print msg box' when doing docmd.openreport


The command you're actually talking about is "DoCmd.OpenReport" I suspect (as in the title, not the body). DoCmd.Open is not supported. I also had a quick check in the Help for you on this and there is no mention of disabling this display. I suspect this is simply a standard (non-configurable) effect of the method.
  #4  
Old January 13th, 2009, 02:12 PM
Member
 
Join Date: May 2007
Posts: 103

re: How to turn off echo of 'print msg box' when doing docmd.openreport


I am using "DoCmd.OpenReport rptname" in my code. What I am trying to find is a way to supress the print window that opens and displays when this code is run. I want that 'invisible' to the user.
  #5  
Old January 13th, 2009, 02:22 PM
NeoPa's Avatar
Administrator
 
Join Date: Oct 2006
Location: London - UK
Posts: 15,473
Provided Answers: 57

re: How to turn off echo of 'print msg box' when doing docmd.openreport


Actually, other than the one slip-up, your question was pretty clear and understandable (Would that all were so).

This is just one of those situations where I can neither answer from my own experience, nor find anything helpful on the web for you. Sorry.
  #6  
Old January 13th, 2009, 02:30 PM
Member
 
Join Date: May 2007
Posts: 103

re: How to turn off echo of 'print msg box' when doing docmd.openreport


I too tried to search on the web and did not find an easy method to do this. Thanks for taking the time to look!
Reply