“FROM子句语法错误”,然后显示对象‘refresh'的方法‘IAdodc’失败

来源:百度知道 编辑:UC知道 时间:2024/06/26 00:40:29
Private Sub Command3_Click()
Dim yj As Long

Adodc2.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\点餐.mdb;Persist Security Info=False"

Adodc2.RecordSource = "select sum(支付金额) as T from 点餐记录表 where 点餐记录表.时间 >= '" & Combo1.Text & "' and 点餐记录表.时间 <= '" & Combo1.Text & "'"

Adodc2.Refresh
Text9.Text = yj
End Sub

DATAGRID 里面记录没有空的
请问各位大侠哪里错误!!
没分了 各位谁愿意就知个招吧!谢谢!

Adodc2.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\点餐.mdb;Persist Security Info=False"
Adodc2.CommandType = adCmdText '加入这句就好啦。
Adodc2.RecordSource = "select sum(支付金额) as T from 点餐记录表 where 点餐记录表.时间 >= '" & Combo1.Text & "' and 点餐记录表.时间 <= '" & Combo1.Text & "'"