技術(shù) 點(diǎn)
- 技術(shù)
- 點(diǎn)
- V幣
- 點(diǎn)
- 積分
- 144573
|
6#
發(fā)表于 2020-4-11 08:35:15
|
只看該作者
改成下面這樣的代碼就可以解決了
- Public Function gIdSeries(ByVal tblName As String) As String
- Dim rs As New ADODB.Recordset
- Dim I As Integer
- Dim strWhat As String
- Dim intID As Long
- rs.Open tblName, CurrentProject.Connection, adOpenKeyset, adLockReadOnly
- Do While Not rs.EOF
- For I = 0 To rs.Fields.Count - 1
- If Trim(rs.Fields(I)) <> "-" Then
- intID = Left(rs.Fields(I), InStr(rs.Fields(I), "-") - 1)
- If intID = 6 Then
- Debug.Print intID
- End If
- If InStr("," & strWhat, "," & intID & ",") = 0 Then
- strWhat = strWhat & intID & ","
- End If
- End If
- Next
- rs.MoveNext
- Loop
- If Len(strWhat) > 0 Then
- gIdSeries = Left(strWhat, Len(strWhat) - 1)
- End If
- rs.Close
- Set rs = Nothing
- End Function
復(fù)制代碼
|
|