Supressing .pdf creation in acOutputTo

[LlamaLima]

Hi,

I am using VBA in Access 2007 and have the following code on a button in a stand alone form (form isn't tied to any data);

DoCmd.OutputTo acOutputReport, "rpt25+Anes", acFormatPDF, "Z:\Erx\Anes25+.pdf", False
DoCmd.OutputTo acOutputReport, "rpt25+Barb", acFormatPDF, "Z:\Erx\Barb25+.pdf", False
DoCmd.OutputTo acOutputReport, "rpt25+CUH", acFormatPDF, "Z:\Erx\CUH25+.pdf", False



The code works fine, the problem is that the second report, "rpt25+Barb" doesn't have any data yet. So I wind up creating a .pdf for my admin to send out that is empty. I create these reports every month. Down the road that second report will have some data at some point and so I want to have that report ready to go when that does happen.

Now is there a way to check to see if the second report has data and if not, jump to the next OutputTo? If the second report does have data, follow thorough with the OutputTo command.

I have tried playing with HasData property, but I don't know how to reference the report from the VBA code on my form.

Thanks!

[rpeare]

yes you can count the number of records in the query driving the report before you print it and if there are 0 records just skip to the next report.

If your report is based on a a query (Call it query1)

You can have code like this

if dcount("*", "Query1") >0 then
'Issue your print command
endif

[LlamaLima]

Rpeare,


Thanks! Yes, the reports are all based on queries. I'll give this a shot on Tuesday.

--Mike