Link to home
Start Free TrialLog in
Avatar of crystalsoft
crystalsoft

asked on

Compile Error "Can't Assign to read only property"

Compile Error "Can't Assign to read only property"

Highlighted on

            !btno = RecvKKL!btno


Private Sub cmdMove_Click()
    
On Error Resume Next

    Command12.Enabled = False
    
    Option1.Enabled = False
    Option2.Enabled = False
    
    Moving_Rec (InputBox("Enter the Memo Number"))

End Sub


Private Sub Moving_Rec(lsno As Double)

'On Error GoTo NGPErrPara:
  
Dim RsCounter As New ADODB.Recordset
Dim BNo

Text1(18).text = lsno
  
''''''''''Connection For Mover.MDB file for transferring data from Trant.MDb to Mover.MDB
    If RecvKKL_Cnn.State = 1 Then RecvKKL_Cnn.Close
        RecvKKL_Cnn.Open "Provider=Microsoft.Jet.OLEDB.3.51;Data Source=" & App.Path & "\Mover.mdb;Jet OLEDB:Database Password=xxxxxxxxxxxxx"

'''''''''Local Recordset Connecting to B_Detail
    
    If RecvLCL.State = 1 Then RecvLCL.Close
        RecvLCL.Open "select * from B_Detail WHERE LsNo = " & Text1(18).text & " and Check = 1", con, adOpenKeyset, adLockOptimistic
        
        
    If RecvKKL.State = 1 Then RecvKKL.Close
        RecvKKL.Open "Select * from B_Detail", RecvKKL_Cnn, adOpenKeyset, adLockOptimistic

    If RecvKKL!btno > 0 Then
        BNo = RecvKKL!btno

        With RecvLCL
        
            .AddNew
        
            !btno = RecvKKL!btno
            !Mode = RecvKKL!Mode

Open in new window

Avatar of cyberkiwi
cyberkiwi
Flag of New Zealand image

Try changing it to

            RecvLCL!btno = RecvKKL!btno
Avatar of crystalsoft
crystalsoft

ASKER


now its highlighted on RecvLCL
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial

OOPS

got it
it was .connection

i changed to .recordset and its working

But another problem appear..

and i ask new question...https://www.experts-exchange.com/questions/26305076/Run-time-error-3021-Either-BOF-or-EOF-is-true-or-the-current-record-has-been-deleted.html

Thanks for quick reply