Array - retrieve certain amount of recods for query
I wish this can help you.
Dim icount, supp As Integer
Dim sStr As String
sStr = ""
For icount = 1 To i
supp = icount Mod 150
If supp = 0 Then
MsgBox sStr
sStr = ""
End If
sStr = sStr & " " & Arr(icount)
Next icount
MsgBox sStr
Bye, Ste'
|