Gathering Information From a ListBox

• • Reply

  19 years ago

  by zordao

  zordao

  , United States

  Joined 19 years ago

  This is probably a stupid question but I can't seem to figure it out.  I have a section where the user  enters information into text1 and they hit the "add" button.  This then sends the text to a listbox, they can do this multiple times.  My question is, when I go to save this information from the list to the database how do I do this.

  Report abuse
• • Reply

  19 years ago

  by streamload

  Michael Balloni

  , United States

  Joined 19 years ago

  For i = 0 to List1.Count - 1
      cConn.Execute ("INSERT INTO TheTable (Field1) VALUES ('" & List1.List(i) & "'")
  Next
  

  
  where cConn is an ADO connection object...

  Report abuse