查询值的数目与目标字段中的数目不同－－请高手帮助！急！

dominicyh · 发表于 2005-12-27 16:53

"查询值的数目与目标字段中的数目不同" 错误提示，这是为什么？看不明白，请高手指点! 如附件中的毛料资料管理窗体中的保存毛料记录，执行时就出现上面提示的错误。多谢！

O4s0im7H.rar (180.73 KB, 下载次数: 30)

dominicyh · 发表于 2005-12-27 17:57

真的很难搞，减少几个字段就可以了

不会有字段的限制吧！

真是没劲！

wwwwa · 发表于 2005-12-30 11:21

你的代码有问题：

STemp = "INSERT INTO 毛料资料"
STemp = STemp & "( 毛料ID,毛类,组别,客户,批号,款号,来毛日期,毛单编号,发毛地,供应商,"
STemp = STemp & "支数,成份,颜色,色号,缸号,来毛重量,验收重量,备注)"
STemp = STemp & "VALUES ('" & Me![毛料ID] & "','" & Me![毛类] & "',"

STemp = STemp & "'" & Me![组别] & "','" & Me![客户] & "',"

STemp = STemp & "'" & Me![批号] & "','" & Me![款号] & "',"
STemp = STemp & "'" & Me![来毛日期] & "','" & Me![毛单编号] & "',"
MsgBox STemp & 4
STemp = STemp & "'" & Me![发毛地] & "','" & Me![供应商] & "',"
MsgB
STemp = STemp & "'" & Me![支数] & "','" & Me![成份] & "',"
STemp = STemp & "'" & Me![颜色] & "','" & Me![色号] & "',"

STemp = STemp & "'" & Me![缸号] & "','" & Me![来毛重量] & "',"

STemp = STemp & "'" & Me![验收重量] & "','" & Me![备注] & "')"

		自动登录	找回密码
密码			免费注册