0

hello

I've been designing a bookStore, tought it's not an easy task. It has been sweating me for no reason,errors pop up in correct statement.

An error pops up saying compliation error: member or method not found in line

adodc.RecordSet.Edit


here is the full code:

Private Sub Command3_Click()
    Dim Deposit As Single
    Dim currentDate As Date
    
    Deposit = Text3.Text
    currentDate = DateValue(Today)
    
    dataDeposit.Recordset.Edit <=== here
    dataDeposit.Recordset.Fields("depositAmount").Value = Deposit
    dataDeposit.Recordset.Fields("depositID").Value = ID
    dataDeposit.Recordset.Fields("studentID").Value = ID
    dataDeposit.Recordset.Fields("date").Value = currentDate
    dataDeposit.Recordset.Update
    dataDeposit.Recordset.MoveNext
End Sub

Do you see anything out of normal?

3
Contributors
2
Replies
3
Views
7 Years
Discussion Span
Last Post by jhai_salvador
0

Yes, that is one of the things implemented with ADO and the ADODC. You do not need to call the edit method like you need to with DAO or the DATA control as it does not exist. Just remove it, the edit line that causes the error, and everything should work fine.

Good Luck

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.