类型不匹配 [英] Type Mismatch

问题描述

大家好，


有点火了 -


我想简单地填写5个字段一个表格来自同名的5个控件，表单上有vb OnButtonClick（）。其中四个控件来自另一个表，其中一个是未绑定的。我的代码位于Access 2007中的.accdb文件中。我没有ADO库引用。指定。我是不是该？


我在SELECT行上收到第一个错误（type mismatch）。这就是它坐着......

Hi, Everyone,

A little fire to put out --

I''m trying to simply populate 5 fields in a table from the same-named 5 controls on a form with vb OnButtonClick(). Four of the controls are sourced to another table, and one of them us unbound. My code is in an .accdb file in Access 2007. I have no ADO library ref. specified. Should I?

I''m getting my first error ("type mismatch") on the SELECT line. Here it is as it sits...

展开 | 选择 | Wrap | 行号

推荐答案

我不知道明白。为什么要通过代码执行此操作而不是将控件绑定到表中的字段？

I don''t understand. Why are you doing this through code instead of binding the controls to the field in the table?

注1）您已将db重置为您的SQL语句。错误。

Note 1) You''ve reset db to become your SQLstatement. Wrong.

如果字段不应该像Rabbit建议的那样绑定到表，则可以使用以下语法：

If the fields are not supposed to be bound to a table as suggested by Rabbit, you can use this syntax:

展开 | 选择 | Wrap | 行号

这篇关于类型不匹配的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！