for i=0 to rs.RecordCount -1 debug.print rs!ID rs.MoveNext next
Public rstTmp As Recordset Dim strDB As String Dim StrSQL As String '-------------------ACCESS--------------------------------------- Set cnDbSr = New Connection
With cnDbSr .Provider = "MSDataShape" .ConnectionString = strDB .CursorLocation = adUseClient .Mode = adModeReadWrite .Open End With StrSQL = "Select distinct ID from 表名" Set rstTmp = cnDbSr.Execute(StrSQL)
'--------------------------------------------------- If rstTmp.RecordCount = 0 Then '| '处理 收尾工作 '| Else '| rstTmp.MoveFirst '| If Not rstTmp.EOF Then '|这一部分应该放在另一个函数里 '写显示的代码,例如 '| Debug.Print rstTmp.Fields("ID").Value '| rstTmp.MoveNext '| End If '| End If '| '----------------------------------------------------
debug.print rs!ID
rs.MoveNext
next
Dim strDB As String
Dim StrSQL As String
'-------------------ACCESS---------------------------------------
Set cnDbSr = New Connection
strDB = "Provider=MSDataShape.1;Data Provider=MSDASQL.1" & _
";Driver={Microsoft Access Driver (*.mdb)}" & _
";DBQ=" & App.Path & "\AAAA.mdb;" & _
";uid=" & _
";pwd="
With cnDbSr
.Provider = "MSDataShape"
.ConnectionString = strDB
.CursorLocation = adUseClient
.Mode = adModeReadWrite
.Open
End With StrSQL = "Select distinct ID from 表名"
Set rstTmp = cnDbSr.Execute(StrSQL)
'---------------------------------------------------
If rstTmp.RecordCount = 0 Then '|
'处理 收尾工作 '|
Else '|
rstTmp.MoveFirst '|
If Not rstTmp.EOF Then '|这一部分应该放在另一个函数里
'写显示的代码,例如 '|
Debug.Print rstTmp.Fields("ID").Value '|
rstTmp.MoveNext '|
End If '|
End If '|
'----------------------------------------------------
msgbox rs.fields("ID")
rs.movenext
loop