Public cnn As New ADODB.ConnectionPrivate Sub Command5_Click()
If deletesj = "" Then
MsgBox "请选择删除记录!"
Else
If MsgBox("时间: " & deletesj & " 确认要删除?", vbYesNo, "信息提示") = vbYes Then
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\data.mdb"
cnn.Execute "delete form [条码记录] where [id]=" & deleteid & ""
End If
End If
End Sub
If deletesj = "" Then
MsgBox "请选择删除记录!"
Else
If MsgBox("时间: " & deletesj & " 确认要删除?", vbYesNo, "信息提示") = vbYes Then
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\data.mdb"
cnn.Execute "delete form [条码记录] where [id]=" & deleteid & ""
End If
End If
End Sub
这明显双引号不对称,你把这一句在DEBUG中打印出来就知道了
没有不对称吧,如果deleteid=1那么输出的SQL语句为:delete form [条码记录] where [id]=1
你真粗心