Search results

YAP, With the last solution I have Run time error 424...

Hi bob, Now I have a syntax error with FROM... Dim strIDs As String Dim strSQL As String Dim varSelect As Variant strSQL = "DELETE * FROM [W1_Budget input] " For Each varSelect In Me.ListInputBudget.ItemsSelected strIDs = strIDs & Me.ListInputBudget.ItemData(varSelect) & "," Next...

The same message as i got with the code of David for each control variable must be Variant or Object

Hi Bob, Also thanks for your code but I have the same error message... :o

Hi Dcrake; Thanks for the code. I've tried to run it but it faild. For Each control variable must be variant or object. is my error message... Sorry :o

Hello, Thanks for your quick answer :-) Yes actually I want it deleted from the table. What do you mean by reverse order? I'm not sure that I understand how to built a string of ID's

Hello, I have a multiple selection listbox (datasource on a tble). I try to delete the selected row from the list box with that VBA: Private Sub Command61_Click() On Error GoTo Err_Exit_Click Dim i For Each i In ListInputBudget.ItemsSelected Dim db As Database Dim rs As Recordset Set db =...