Object or Provider cannot perform requested operation

  • Thread starter Thread starter Andy Levy
  • Start date Start date
A

Andy Levy

I get the error "Object or Provider is not capable of performing requested
operation" when running this code. I have marked the line which is causing
an error.
Im not sure why it cant do this. Thanks
AL

Public Function setApros()

Dim try As ADODB.Recordset
Set try = New ADODB.Recordset
try.Open "SELECT itemID, currentValue, currentValueApro FROM items ORDER BY
itemID", CurrentProject.Connection, adOpenStatic

try.MoveFirst

Do Until try.EOF

If calcSumCurValue(try!itemID) = 0.00000000001 Then
try!currentValueApro = try!currentValue '<<<<<<< ERROR
Else
try!currentValueApro = calcSumCurValue(try!itemID)
End If

try.MoveNext
Loop
End Function
 
Back
Top