-
February 24th, 2014, 09:21 AM
#1
Do while loop
Can anyone please help me with a Do while Not loop.
I'm very new to programming:
I need to check and print a list, and limit it to 5 names.
Do While Not rsP.EOF And iCount > 5
sLT = sLT & rsP![Name] & vbNewLine
iCount = iCount + 1
rsP.MoveNext
Loop
If rsP.RecordCount > 5 Then
sLT = sLT & "..."
End If
right now it will not print the list, if I take out iCount > 5, it prints, but I need to limit it to only 5 names maximum to print?
Thanks
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|