|
本帖最后由 danhanqing 于 2018-5-29 13:23 编辑
Private Sub 批量销单作业_Click()
lvname = "ListView6"
Dim Conn As adodb.Connection
Set Conn = LinkDB
Dim Rs As New adodb.Recordset
For i = 1 To Me.Controls(lvname).ListItems.Count
已付 = Me.Controls(lvname).ListItems(i).SubItems(9)
单据编号 = Me.Controls(lvname).ListItems(i).SubItems(1)
sql = "Update 财务结算总表 set 已付=已付 ,尚欠=0 where 单位名称='" & Me.Controls(页面名称 & "_" & "单位名称") & "' and 单据编号='" & 单据编号 & "'"
Conn.Execute sql
Next i
Conn.Close
Set Rs = Nothing: Set Conn = Nothing
MsgBox "销单成功!"
End Sub
错误提示是:标准表达式中数据类型不匹配。
可我检查数据库中,已付、尚欠、单据编号 字段均为数值类型……
谢谢老师们点拨!
|
|