unbound和null [英] unbound and null
问题描述
我用过数据输入一些未绑定的文本框
他们是数字，日期/时间
用户将数据输入这些字段;当点击''添加新''按钮时，
rs将更新并通过向其指定''null''值来清除这些未绑定的控件;但当我点击添加新按钮时，我会收到如下错误：
"你试图将Null值分配给一个不是Variant数据类型的变量
请帮帮我
谢谢
i''ve used for data entry some unbound text boxes
they are of number, date/time
user will enter data into these fields; when click ''Add New'' button,
rs will update and these unbound controls to be cleared by assinging ''null'' value to it; but when i click ''add new'' button i get an error like this:
"you tried to assign the Null value to a variable that is not a Variant data type"
pls help me
thanks
推荐答案
抱歉Kaib
您必须在添加新按钮后面发布代码并告诉我们代码停止时突出显示的行。
Mary
Sorry Kaib
You will have to post the code behind the add new button and tell us what line is highlighted when the code stops.
Mary
我用于数据输入一些未绑定的文本框
它们是数字，日期/时间
>
用户将数据输入这些字段;当点击''添加新''按钮时，
rs将更新并通过向其指定''null''值来清除这些未绑定的控件;但当我点击添加新按钮时，我会收到如下错误：
"你试图将Null值分配给一个不是Variant数据类型的变量
请帮助我
谢谢
i''ve used for data entry some unbound text boxes
they are of number, date/time
user will enter data into these fields; when click ''Add New'' button,
rs will update and these unbound controls to be cleared by assinging ''null'' value to it; but when i click ''add new'' button i get an error like this:
"you tried to assign the Null value to a variable that is not a Variant data type"
pls help me
thanks
''我会假设未绑定控件您输入数据的是文本
''框。不要试图通过为它们分配Null值来清除它们，而是vbNullStyring或空字符串（"）例如
''I''ll assume the Unbound Controls into which you are entering data are Text
''Boxes. Do not attempt to clear them out by assigning the Null value to them, but rather the vbNullStyring or the empty string ("") e.g.
我不确定'是的ADezii。
我认为这是指代码中的DIMmed变量。大多数表单控件都可以使用Null。甚至记录字段很可能（取决于设置而不仅仅是它们的类型）。
我们需要回到Mary的帖子并请求用户发布使用的相关代码。
I''m not sure that''s right ADezii.
I think this is referring to a DIMmed variable in the code. Most form controls take Nulls ok. Even Record Fields are likely to (depending on set up rather simply their type).
We need to go back to Mary''s post and request the user posts the relevant code used.
这篇关于unbound和null的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
