Hi All,

I have a listview that contains users and I want to multiselect them and click a remove button and have them deleted from the Access Database.

Any ideas??

Many thanks,

Paul

Hi Paul,

If you would like to multi-select the users from a ListView control then you have to check on the option for checkboxes.

Do This
--> Right click on the ListView control
--> Click Properties
--> In the General Tab select CheckBoxes
--> Click Column Headers Tab
--> Assign Appropriate Names
--> Click OK

Now you will able to select multiple users from the same ListView Control.

If you want to delete the selected users:

If ListView1.ListItems.Count > 0 Then
    For i = 1 To ListView1.ListItems.Count
        If ListView1.ListItems(i).Checked = True Then
            SQL "Delete from User_Table Where USer_Name ='" & Trim(ListView1.ListItems(i).Text) & "'"
            'Execute the delete statement
            i = i - 1
        End If
        If i = ListView1.ListItems.Count Then
            Exit Sub
        End If
    Next
End If

Hope this helps,

Thanks,

Lalit
Life Means More...;)

Paul,
I suggest you create a field with data type Yes/No where you have you list in a table. For example, field name remove. Then create a form, with a view: Continuous Forms. In this form create a check box bound to the remove field. Then create command button with a vb code
to delete all remove check boxes that are checked or with Yes value.
I hope this helps.
john