Search results

I'll try those suggestions but it will be a few days before I can get back with the results - I will be unavailable. Thanks for your assistance - I will post early next week with the outcome. Hopefully you will be able to see how the test comes out.

Sorry, I sent the wrong one. This should be what you are asking for.

Ok, let's try this one. Did the other screenshots come out clear enough?

Hopefully these are the screenshots you were asking about. If not, let me know and I can try again.

Unfortunately, my Manager will not authorize me to post the database. Is there something in particular that you are looking for that I could look into? I did try changing my default printer to send the pages to 2 different printers (all 3 of the printers are different models of HP LaserJet...

I changed the VBA to the following to allow me to work with the report: DoCmd.OpenReport stDocName, acPreview DoCmd.PrintOut acSelection, 1, 1, , 2 The CoCmd.PrintOut command sent 2 copies of page 1 to the printer - 1 blank then 1 with the data. I then hit the printer icon in the...

Thanks for the input. It does not happen with any other databases and it does not happen if I put this report into preview mode and manually print it - only when I use docmd.printout to send it to the printer.

How do I go about showing the screenshot? I don't have access to a URL to post the picture to and I cannot just paste it into a response.

Thanks for the welcome and the quick reply. There is no grouping set up in the report. There are 3 sub-reports that the data for the main report is extracted from, but they are not printed. There are no header or footer sections - only the detail section. It's actually a pretty simple report.

I am trying to print the first page of a report using the following VBA: DoCmd.SelectObject acReport, "rptMyReport", True DoCmd.PrintOut acPages, 1, 1, , 2 The issue I have is that the first copy always comes out as a blank page. Setting the number of copies to 1 gives me only a single blank...