How to exclude a report from printing if it has no information in it ?


Question

This is probably a pretty newbie question, but what I'm looking to do is this. I have a print macro that allows me to print all my daily forms with one buttom push. However, one of my reports can sometimes have no info in it and I'd like to exlude it from printing... How?

Answer

From: Shamil Salakhetdinov <shamil@marta.darts.spb.ru>
Tc: ACCESS-L <ACCESS-L@PEACH.EASE.LSOFT.COM>
Subject: Re: How to exclude a report from printing if it has no information init.
Date: 14 May 1998 0:58

Hank,

Check Online help - HasData property and NoData event.

This function is one of the possible answers to your question:

Private Sub Report_NoData(Cancel As Integer)
   MsgBox "No Data !"
   Cancel = True
End Sub

HTH,
Shamil


HOME    TOPICS

Copyright © 1998–1999 by Shamil Salakhetdinov.
All rights reserved. Terms of use.

Last updated: October 10, 2006

Published also here at 4TOPS: How to exclude a report from printing if it has no information in it ?