vb标准表达式中数据类型不匹配

来源:百度知道 编辑:UC知道 时间:2024/06/10 02:48:42
求救啊!!!!!!!!!!!111
Public Sub 更新wq余额(ByVal x$, ByVal y$, ByVal z$)
'x:表名(物业费信息、取暖费信息表),y:字段(业主ID),
'z:从组合框获取的物业费ID,用于查询满足条件的记录
Dim curdb As Database
Dim curRS As Recordset
Dim X1 As Single, strSQL$, flag As Boolean
Dim Y2 As Single
Set curdb = CurrentDb
strSQL = "Select * From " & x
strSQL = strSQL + " Where " & y & " = '" & z & "'"
Set curRS = curdb.OpenRecordset(strSQL)

'Y2应收金额
Y2 = curRS.Fields("收费标准(元/平米)") * curRS.Fields("建筑面积")
'X1为余额,
X1 = curRS.Fields("实收金额") - Y2 - curRS.Fields("减免金额")
flag = True

curdb.Execute "UPDATE " & x & " SET 应收金额 =" & Y2 & ",余额 =" & X1 & _
",是否收缴 = " & flag & " Where " & y & " ='" & z & "'"
curdb.Close

End Sub

curdb.Execute "UPDATE " & x & " SET 应收金额 =" & Y2 & ",余额 =" & X1 & _
",是否收缴 = " & flag & " Where " & y & " =" & z

数据类型不匹配,看看你数据库中的字段,如果是字符型的就用'"& ss &"',如果是数字型的就用"& ss &"
字符型的带引号,数字型的不带