我用的Access数据库,在打印程序中,遇到这种问题,代码如下:
.....................
DataEnv1.Connection1.Open
DataEnv1.Connection1.Execute "DELETE * FROM TempH"
intTemp = List1(1).ListCount
For I = 0 To intTemp - 1
strTemp = List1(1).List(I)
strTemp1 = "INSERT INTO TempH SELECT * FROM 不合格 WHERE " _
& "报告编号='" & .Bgbh & "' AND 样品编号='" & strTemp & "'"
DataEnv1.Connection1.Execute strTemp1 ' ----------------运行到此处,显示错误提示 信息:“查询的数目与目标字段中的数目不同”
Next I
DataEnv1.Connection1.Close
strTemp1 = "SELECT * FROM TempH ORDER BY 样品编号,次数"
Adodc2.RecordSource = strTemp1
DataEnv1.Connection1.Open
DataEnv1.Connection1.Execute "DELETE * FROM TempHT"错误出现在“DataEnv1.Connection1.Execute strTemp1 ”处,错误信息提示为“查询的数目与目标字段中的数目不同”
.....................
DataEnv1.Connection1.Open
DataEnv1.Connection1.Execute "DELETE * FROM TempH"
intTemp = List1(1).ListCount
For I = 0 To intTemp - 1
strTemp = List1(1).List(I)
strTemp1 = "INSERT INTO TempH SELECT * FROM 不合格 WHERE " _
& "报告编号='" & .Bgbh & "' AND 样品编号='" & strTemp & "'"
DataEnv1.Connection1.Execute strTemp1 ' ----------------运行到此处,显示错误提示 信息:“查询的数目与目标字段中的数目不同”
Next I
DataEnv1.Connection1.Close
strTemp1 = "SELECT * FROM TempH ORDER BY 样品编号,次数"
Adodc2.RecordSource = strTemp1
DataEnv1.Connection1.Open
DataEnv1.Connection1.Execute "DELETE * FROM TempHT"错误出现在“DataEnv1.Connection1.Execute strTemp1 ”处,错误信息提示为“查询的数目与目标字段中的数目不同”
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货