anvg, Не подскажите как впихнуть значение с ListBox в запрос?
[vba]Код
Private Sub CommandButton1_Click()
Dim CON As Object: Set CON = CreateObject("ADODB.Connection")
Dim iRow&, iCol&, LastRow&, LastCol&
Dim sFields$, sValues$, sSQL$
CON.Open IIf(Val(Application.Version) < 12, "Provider='Microsoft.Jet.OLEDB.4.0'", "Provider='Microsoft.ACE.OLEDB.12.0'") & _
"; Data Source=" & ThisWorkbook.Path & "\Data2.accdb" & ";Mode=Share Deny None; Jet OLEDB:Database;"
sSQL = "DELETE FROM [table] WHERE [SERIAL ID] = 'Me.ListBox1.List(I)';"
CON.Execute sSQL
CON.Close
End Sub
[/vba]