Help with printing Reports in background.

[jk8721]

Hello all. I've searched all over and can't find exactly my situation. I'm trying to print several different reports, each with their own filters, based on a single query, which is based upon two joined tables. Did I mention I don't have a clue about code? Oh well. I made a command button that prints all the reports at the same time but the problem is that I get a box in the middle of my screen that says the job is being sent to the printer. The box only last for a second but it appears for each report that's being printed, and there's a bunch. It keeps the user sitting there waiting for it to finish. My question is, is there a way to not display that box or window or whatever it's called. Failing that, is there a way to put it on one print job so it's much faster. Bear in mind that there is different filter criteria on each report and I need two copies of each. Any help would be greatly appreciated. Thanks in advance.

Jeff

 

[Malcy]

Hi
I think you should be able to modify the VBA code on the command button to turn the warnings off.
If you hit the code button with the form in design you should see the code that is printing off the reports.
Before that code insert the line

DoCmd.SetWarnings False

And at the end of the last line of code printing off reports put in a new line of code

DoCmd.SetWarnings True

Then save the code and compile.

You need both lines. One switches off the warnings and the other turns them back on again when you are finished.

Hope this helps

Malcy

 

[jk8721]

Thanks for the help but...

Thanks for the suggestion but I couldn't seem to get it to work. When I hit the code button, after selecting it, it takes me to some code that doesn't even look like my macro. Next I thought well may the set warning value could be set off and on at the beginning and the end of the macro. I tried it but it didn't work. I don't think its really a warning. It's just a box that pops up saying a print job has started. I wouldn't mind but with 30 print jobs or so it will just sit there blinking until it's done. It makes it seem kind of clumsy. If I could combine all the reports into one report (using Subreports) and then print once (with 2 copies) that would be great. I spent all day trying to figure it out with no luck. I tried to use the filter property setting for each report to only print out the reports I need but it's a mess. I get a lot of duplicates and also a lot of blank pages. I've tried changing the primary reports record source every which way and linking the Parent and Child fields. No luck. One other possibility would be if I could combine all my print jobs into one print job, behind the scenes. Again, I'm pretty new to understanding code and where it all goes. Anyway, thanks again for you consideration.

Seacrest Out,
(Sorry, couldn't resist)

 

[Malcy]

OK
Sorry I hadn't picked up you were using a macro.
I seem to recall that you can use the macro to set warnings off.
When you open the macro in design you should get a grid showing the actions the macro is to take.
If you insert a new action at the top of your list in the macro and select SetWarnings with the value no, then at the last line of the macro add a new action SetWarnings and set the value to yes.
Hope this is of more use.
Best wishes

Malcy

 

[jk8721]

Thanks again but it didn't work...

Thanks again for your reply but I tried that earlier when you gave me the idea about turning the warnings off. It still didn't work. I don't think it's really a warning box it just a little square that pops up for about a second and tells me that a print job is now being sent to my printer. Thanks.