|
如何将这段代码里面的数据库位置改成网络的,网络地址:\\10.127.10.234\中转文件\贴片回流焊数据\QC报表数据库\gkzp.mdb
Private Sub CommandButton6_Click()
Dim cnn As Object, rs As Object, sql$, i&, m&, c As Range
If Len(Range("b3").Value) = 0 Then MsgBox " 请在 B3 单元可输入要查询的机型", vbCritical + vbOKOnly: Exit Sub
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Application.EnableEvents = False
Set cnn = CreateObject("adodb.connection")
Set rs = CreateObject("adodb.recordset")
cnn.Open "provider=microsoft.jet.oledb.4.0;data source=" & ThisWorkbook.Path & "\gkzp.mdb;Jet OLEDB:Database Password=263214685"
sql = "select 班组,生产线,不良类型,不良位置,不良数量,生产日期,单机点数,总点数,不良总数,操作员,生产周期,产量,疵点率 from gkzp where 机型='" & [B3] & "'"
rs.Open sql, cnn, 1, 3
If rs.RecordCount > 0 Then
If rs.RecordCount > 1 Then
' MsgBox Target.Value & "共有" & rs.RecordCount & "条记录", vbInformation
For i = 1 To rs.RecordCount
m = 0
For Each c In Range("F3,J3,B4,F4,J4,L4,B5,F5,J5,L6,L5,J6,K8")
c.Value = rs.Fields(m).Value
m = m + 1
Next
If i < rs.RecordCount Then
If MsgBox("共有" & rs.RecordCount & "条记录,这是第" & i & "条记录,单击“是”显示下一条,单击“否”退出程序。", vbInformation + vbYesNo, [B3] & "共有" & rs.RecordCount & "条记录") = vbNo Then Exit For
End If
rs.MoveNext
Next
Else
For Each c In Range("F3,J3,B4,F4,J4,L4,B5,F5,J5,L6,L5,J6,K8")
c.Value = rs.Fields(m).Value
m = m + 1
Next
MsgBox "获取成功!" '提示可要可不要
End If
Else
Range("F3,J3,B4,F4,J4,L4,B5,F5,J5,L6,L5,J6,K8") = ""
End If
Application.ScreenUpdating = True
Application.DisplayAlerts = True
Application.EnableEvents = True
rs.Close
Set rs = Nothing
cnn.Close
Set cnn = Nothing
End Sub
- Private Sub CommandButton6_Click()
- Dim cnn As Object, rs As Object, sql$, i&, m&, c As Range
- Dim strDatabase$
- If Len(Range("b3").Value) = 0 Then MsgBox " 请在 B3 单元可输入要查询的机型", vbCritical + vbOKOnly: Exit Sub
- strDatabase = "\\10.127.10.234\中转文件\贴片回流焊数据\QC报表数据库"
- Application.ScreenUpdating = False
- Application.DisplayAlerts = False
- Application.EnableEvents = False
- Set cnn = CreateObject("adodb.connection")
- Set rs = CreateObject("adodb.recordset")
- cnn.Open "provider=microsoft.jet.oledb.4.0;data source=" & strDatabase & "gkzp.mdb;Jet OLEDB:Database Password=263214685"
- sql = "select 班组,生产线,不良类型,不良位置,不良数量,生产日期,单机点数,总点数,不良总数,操作员,生产周期,产量,疵点率 from gkzp where 机型='" & [B3] & "'"
- rs.Open sql, cnn, 1, 3
- If rs.RecordCount > 0 Then
- If rs.RecordCount > 1 Then
- ' MsgBox Target.Value & "共有" & rs.RecordCount & "条记录", vbInformation
- For i = 1 To rs.RecordCount
- m = 0
- For Each c In Range("F3,J3,B4,F4,J4,L4,B5,F5,J5,L6,L5,J6,K8")
- c.Value = rs.Fields(m).Value
- m = m + 1
- Next
- If i < rs.RecordCount Then
- If MsgBox("共有" & rs.RecordCount & "条记录,这是第" & i & "条记录,单击“是”显示下一条,单击“否”退出程序。", vbInformation + vbYesNo, [B3] & "共有" & rs.RecordCount & "条记录") = vbNo Then Exit For
- End If
- rs.MoveNext
- Next
- Else
- For Each c In Range("F3,J3,B4,F4,J4,L4,B5,F5,J5,L6,L5,J6,K8")
- c.Value = rs.Fields(m).Value
- m = m + 1
- Next
- MsgBox "获取成功!" '提示可要可不要
- End If
- Else
- Range("F3,J3,B4,F4,J4,L4,B5,F5,J5,L6,L5,J6,K8") = ""
- End If
- Application.ScreenUpdating = True
- Application.DisplayAlerts = True
- Application.EnableEvents = True
- rs.Close
- Set rs = Nothing
- cnn.Close
- Set cnn = Nothing
- End Sub
复制代码
|
|