VB Code:
  1. Dim sfile As String
  2. sfile = App.Path & "\messages.mdb"
  3.  
  4. Set db = OpenDatabase(sfile)
  5. With db
  6. Set rstComm = .OpenRecordset("select * from [message] where [Type] = 'Internet'")
  7.  With rstComm
  8.     .MoveFirst
  9.     Do While Not .EOF
  10.         List1.AddItem .Fields("name")
  11.      
  12.        
  13.         .MoveNext
  14.     DoEvents
  15.     Loop
  16. End With
  17. End With

that is mine