View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
GF GF is offline
external usenet poster
 
Posts: 5
Default Printing problem

Nick

Firstly, thanks for the reply.

Within the same routine we have been able to print fine, but when a more
detailed query is given then it does not print. Saying that if we put a
message box on to stop the routine then it prints. I am a bit lost as to why.

Thanks

"NickHK" wrote:

gf,
Not sure if this is it, but are the querytables have .BackgroundRefresh=True
?

NickHK

"gf" wrote in message
...
I am trying to print a series of reports that are retrieving information

from
a data source using VBA. If I place a msgbox in between the print requests
the printout
succeeds. If I do not do this it does not print. It is as if the printer
cannot print if the retrieval is not fast enough. Is there a way to put a
delay in possibly.
.