如果没有数据,则停止输出报告 [英] Stop outputing Report if NO Data
问题描述
我有VBA代码,用于将2个报告输出到快照格式以便通过电子邮件发送。当我在没有数据的情况下在报告上添加取消时,即使存在数据,第二个报告也不会输出
I have VBA code that is to output 2 reports to snapshot format for emailing. When I add a cancel on the report if no data, the second report will not output even when there is data
推荐答案
我有VBA代码,用于将2个报告输出到快照格式以便通过电子邮件发送。当我在没有数据的情况下在报告上添加取消时,即使存在数据,第二个报告也不会输出
I have VBA code that is to output 2 reports to snapshot format for emailing. When I add a cancel on the report if no data, the second report will not output even when there is data
如果没有数据,你如何取消报告?
这段代码在哪里?请发布整个子程序...(我注意到你已经将警告设置为假...希望稍后在这段代码中你将它们恢复为真!)
问候,
Scott
How are you cancelling the report if no data?
Where does this code reside? Please post the entire sub-routine... (I notice you have set your warnings to false... hopefully later in this section of code you return them to true!)
Regards,
Scott
Scott
执行输出的代码是commad buton。取消事件在无数据中。在报告上。这是错的吗?我应该在其他地方处理Do数据吗?
是的,在Select语句结束时警告会重新开启。
谢谢
Troy
Scott
The code to execte the out put is a commad buton. The Cancel event is in the "no Data" on hte report. Is this wrong? Should I be handling the Do data thig somewhere else?
Yes the warnings get set back to on at the end of the Select statement.
Thanks
Troy
Scott
执行输出的代码是commad buton 。取消事件在无数据中。在报告上。这是错的吗?我应该在其他地方处理Do数据吗?
是的,在Select语句结束时警告会重新开启。
谢谢
特洛伊
Scott
The code to execte the out put is a commad buton. The Cancel event is in the "no Data" on hte report. Is this wrong? Should I be handling the Do data thig somewhere else?
Yes the warnings get set back to on at the end of the Select statement.
Thanks
Troy
为了让我的想法更加清晰,取消究竟是如何调用的?我知道你这样做是在报告的On No Data事件下...我的问题:它是通过表达式,代码,宏取消的吗?如果是代码,请发布用于取消的代码。
问候,
Scott
To get this a little clearer in my mind, how exactly is the Cancel called? I understand that you are doing this is under the On No Data event of the report... My question: is it cancelled through an expression, code, macro?? If code, please post the code used to cancel.
Regards,
Scott
这篇关于如果没有数据,则停止输出报告的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!