ListView Help..

Hi i'm new to VB6 and i just wanted to ask how to save the columns in a ListView to an Access DB... The format i use to save individual textbox to an Access DB is....

With adorecordset
 .Fields!Name = Text1.Text
 .Fields!Address = Text2.Text
 .Fields!Phone = Text3.Text
End WIth

I just wanted to know how to do somthing like this with a ListView..

Thank You!

bad_robot

Newbie Poster

2 posts since Sep 2005

Reputation Points: 10

Solved Threads: 0

5 Years Ago

Its me again i figured out how to save a row in a ListView into an ACCESS DB its something like this...

Private Sub Command2_Click()
    With adoRecordSet
        .AddNew
        .Fields!Name = itemToAdd.SubItems(1)
        .Fields!Address = itemToAdd.SubItems(2)
        .Fields!Phone = itemToAdd.SubItems(3)
        .Update
    End With

...but this only saves the first row.... i want to save all the rows at the same time with just one click of the command button..... Hope someone could help me..... Thanks.... Maraming Salamat :mrgreen:

bad_robot

Newbie Poster

2 posts since Sep 2005

Reputation Points: 10

Solved Threads: 0

This question has already been solved

You