报告显示#Error当Recordset为空时 [英] Report Shows #Error When Recordset Empty
问题描述
嗯,我得到它的工作,与Is Not Null功能,我把它放在Weekstart字符串中,它工作。非常感谢你的帮助。可悲的是,我还有另外一个小问题,并没有做到。
我遇到的新问题是这是我的最后一件大事,所以我更新了所有的我的表中的数据,所以所有报告中都没有任何记录。所以我的总计数在我的报告中都是0,但是由于一些奇怪的原因而不是0,它们是错误的,我不知道为什么,但是我的宏和一些删除查询停止工作因为它返回了一个错误的0我已经开始了解gaurd。
well i got it to work, with the Is Not Null fuction, I put it in the Weekstart string and it worked. So thank you very much for all the help. Saddly i have another small problem that doesn''t make sence.
The new problem I have is that this was my last big thing, so I updated all of the data in my table and so all the reports do not have any records in them yet. So all of my total counts are 0 in my reports but instead of 0 they are Errors for some wierd reason, and i am not sure why at all, but my macros and some delete querys stoped working becouse it is returning an Error insted of 0. I have got caught way off gaurd with that.
推荐答案
这个被拆分的线程是在查询中无效使用Null 。
当绑定记录集为空时会发生这种情况。
你可以通过检查OnOpen事件过程中的状态来处理这个问题。
Me.Recordset.EOF是你需要检查的。
This happens when the bound recordset is empty.
You can handle this by checking the status in the OnOpen event procedure.
Me.Recordset.EOF is what you need to check.
我不知道在打开的偶数程序中有任何东西,我找到了一个将null设置为零的公式,但它不起作用。
I do not have anything in the on open even procedure, i found a formula that sets null to zero but it doesn''t work.
这篇关于报告显示#Error当Recordset为空时的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!