【access小品】断号列表函数

时　间:2011-04-23 21:08:59
作　者:煮江品茶   ID：10802  城市：武汉
摘　要:断号列表函数
正　文:

不是什么精妙的东西。给自己留一个算法资料而已。

点击下载此附件

Function ValList(tbname As String, fldname As String) As String
Dim rs As New ADODB.Recordset
Dim i As Long, j As Long
Dim n As Long
rs.Open tbname, CurrentProject.Connection, adOpenKeyset, adLockOptimistic
rs.MoveLast
n = rs.Fields(fldname).Value
rs.MoveFirst
For i = 1 To n
    If i < rs.Fields(fldname).Value Then
        For j = i To rs.Fields(fldname).Value - 1
            ValList = ValList & j & ";"
        Next
        i = rs.Fields(fldname).Value
    End If
    rs.MoveNext
Next
rs.Close: Set rs = Nothing
End Function