Senin, 12 September 2011

RE: [MS_AccessPros] How do you stop the report if the query produces no records

There is an On No Data event in the report. You can cancel the report. You would need to trap error 2501 in the code that opens the report.

Duane Hookom
MS Access MVP

To: MS_Access_Professionals@yahoogroups.com
From: thomas_lam_us@yahoo.com
Date: Tue, 13 Sep 2011 00:06:05 +0000
Subject: [MS_AccessPros] How do you stop the report if the query produces no records


Running 2007 Access, how can you turn off printing the report if the query result produce no records? Is there some simple way in the report to stop printing a blank page when no records are return?

Thanks,
Thomas


[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

Tidak ada komentar:

Posting Komentar