|
发表于 2014-9-10 09:25
|
显示全部楼层
本楼为最佳答案
- Private Sub CommandButton4_Click() '修改
- Dim cnn As ADODB.Connection
- Dim rs As ADODB.Recordset
- Dim myworkname As String, n As Integer, sql As String
- Dim ws As Worksheet
- Application.ScreenUpdating = False
- Set cnn = New ADODB.Connection
- With cnn
- .Provider = "Microsoft.Jet.Oledb.4.0"
- .Connectionstring = "Extended Properties=Excel 8.0;" & "Data Source=" & ThisWorkbook.FullName '建立数据库连接
- .Open
- End With
- myworkname = Worksheets("产量库").Name
- sql = "select * from [" & myworkname & "$] where 日期='" & ComboBox1.Text & ComboBox2.Text & "' and 类别='" & ComboBox3.Text & "'"
- Set rs = New ADODB.Recordset
- rs.Open sql, cnn, adOpenKeyset, adlockoptimistic
- n = rs.RecordCount
- If n = 0 Then
- 'MsgBox "没有可供修改的数据!!!", 1 + 64, "产量台账!!!", vbInformation
- MsgBox "没有可供修改的数据!!!", 1 + 64, "产量台账!!!"
- End If
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|