Help Please! Populate Listbox from Access?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • edwordsigh
    New Member
    • Dec 2006
    • 1

    #1

    Help Please! Populate Listbox from Access?

    Hello All! I would like to know where I can get started on a problem I've been having. I am currently trying to populate a listbox in visual basic from an access database file. Specifically, I am making a web browser and I want to record history and favorites and have them be written on the access database file, then be read and populated into the listbox on the visual basic form. Can anyone help me get started?
  • neo008
    New Member
    • Jun 2007
    • 85

    #2
    Check n Try,

    Code:
    adodc1.refresh
    dim i as integer
    dim j as integer
    
    adodc1.recordsource="Select FAVNAME from FAVTABLE_
     where CONDITION"
    adodc1.refresh
    adodc1.recordset.movefirst
    list1.clear
    
    j=val(adodc1.recordset.recordcount)
    
    for i=0 to i=j
    List1.AddItem FavName.Text 
    'FavName IS TEXT FIELD WITH WHICH YOUR REQUIRED FIELD IS BOUND WITH SELECTED DATA
    
    adodc1.Recordset.MoveNext
    Next i
    NE☼

    Comment

    Working...