Prevent printing empty reports 1

[kaatjev]

Re: thread 816550 (

http://www.tek-tips.com/viewthread.cfm?qid=816550&page=1)

When looping through the office ID on my tables, it calls up each client. However, when there are no orders from that client, it sends a blank report to the e-mail address.

How do I prevent this from happening?

 

[dhookom]

Can't you use DCount() or something in code to determine the number of records that would get returned by your report?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[kaatjev]

Thank you!
That is exactly what I needed.

I added

recCount = DCount("[ACCESSION]", "Query1")
   If recCount > 0 Then
      DoCmd.SendObject acSendReport, "CCL", acFormatRTF, rs("E-MAIL ADDRESS"), "", "", "Daily Census Report", "testing daily census", False
   End If

and it no longer sends me a blank report.