Error "Method or Data Member not found" here is my code if any one may solve my problem.
Code:
Dim conDataConnection As Connection
Dim strSQL As String
Dim lstSel As ListItem
Set conDataConnection = New Connection
conDataConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & App.Path & _
"\data.mdb;Persist Security Info=False"
For Each lstSel In ListView1.LisItems
strSQL = "Insert Into sale (date, billno, partycode) Values (" & _
"'" & lstSel.Text & "', " & _
"'" & lstSel.SubItems(1) & "', " & _
lstSel.SubItems(2) & ")"
conDataConnection.Execute strSQL
Next
conDataConnection.Close
Set conDataConnection = Nothing
Comment