Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Need help for my vb program (Method or Data Member not found)

This coding gives me error [ Compile Error : Method or Data Member not found ]
It runs on some machines correctly and on some it gives error at run time. Why ?

Private Sub cmdSearch_Click()

Dim db As DAO.Database
Dim rs As DAO.Recordset

Set db = OpenDatabase("D:ill printingBill.mdb")
Set rs = db.OpenRecordset("Bill", dbOpenDynaset)
rs.MoveFirst
While Not rs.EOF
If rs("name") = txtSearch.Text Then

Set lst = lst.ListItems.Add(, , Format(Sl, "00"))
'lst.SubItems(1) = ""
'lst.SubItems(2) = ""
'lst.SubItems(3) = ""
'lst.SubItems(4) = ""
lst.GridLines = True

lst.SubItems(1) = rs("Particular")
lst.SubItems(2) = rs("qty")
lst.SubItems(3) = rs("rate")
lst.SubItems(4) = rs("amount")
txtNtotal.Text = Format(Val(txtNtotal.Text) + Val(txtTOTAL), "0.00")
rs.MoveNext
End If
rs.MoveNext
Wend
Sign In or Register to comment.