Hi
I wonder how to extract just rs("Email")
from this code
If rs.RecordCount = 0 Then
Exit Function
End If
rs.MoveLast
rs.MoveFirst
max = rs.RecordCount
rs.MoveFirst
LstData3.Clear
For i = 1 To max
LstData3.AddItem rs("Email")
rs.MoveNext
Next i
I have 10 different person in the databas but only
3 with email account
I will in an list3 that just thoose wich have email shall be visible
how to do that, and if the databas is filled with more email adess
it shall become vissible in the list3