Access 2003中的子窗体中没有数据的#Error [英] #Error from no data in a subFORM in Access 2003

问题描述

我搜索了帮助文件，发现在尝试从没有HasData属性数据的subREPORT计算数据时可以绕过#Error结果，但是无法弄清楚如何使用子表单执行此操作。 br /> Microsoft帮助


我甚至试图将visible属性设置为no，如果它没有值，但是显然Access认为＃Error作为一个价值。


我不知道VBA，但我正在努力学习。如果解决方案需要大量的VBA，请详细解释。


谢谢。

I searched the Help files and found that you can get around the #Error result when trying to calculate data from a subREPORT which has no data with the HasData property, but can not figure out how to do it with a subform.
Microsoft Help

I even tried to set the visible property to no if it didn''t hold a value, but apparantly Access considers "#Error" as a value.

I do not know VBA, but am trying to learn. If the solution requires a great deal of VBA, please explain the details.

Thank you.

推荐答案

什么是控件的控件来源设置为？

我用简单的绑定控件不能得到它。

What is the Control Source of your control set to?
I don''t get that ever with my simple bound controls.

我有六个子表单。控件正在添加每个控件的总和。有时一个或多个子表单没有数据，因此#Error。


我试图使控件（位于主窗体上）不可见并设置可见如果它的值大于零，则属性为yes，但是会出现类型不匹配错误。


我尝试过条件格式，使文本与我的表单颜色相同'的背景，然后如果值大于零则将其更改为红色，但它根本不起作用。


我已尝试处理所有nz我的子表单。


我看到子报表有一个HasData属性，但不知道是否也适用于子表单。无论如何，我也不能让它为子报告工作。

I have six subforms. The control is adding the sum from each of them. Sometimes one or more of the subforms has no data, hence #Error.

I''ve tried to make the control (which is located on the main form) invisible and set the visible property to yes if it''s value is greater than zero, but get a type mismatch error.

I''ve tried conditional formatting, making the text the same color as my form''s background, then change it to red if the value is greater than zero, but it doesn''t work at all.

I''ve tried dealing with nz in all of my subforms.

I see there is a HasData property for subreports, but don''t know if that applies to subforms, as well. No matter, I can''t get it to work for the subreport, either.

什么是你的控件集的Contro Source到了？

我用简单的绑定控件不能得到它。

What is the Contro Source of your control set to?
I don''t get that ever with my simple bound controls.

顺便说一下，这是一个未绑定的控件。

By the way, this is an unbound control.

这篇关于Access 2003中的子窗体中没有数据的#Error的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！