After have been created some records from MS Access 97 (OpenRecordset DAO)
to SQL70 database :
For lngTemp = Polises_No To Polises_Lidz Step 1
With rstApdrXX
.AddNew
!PIEGADATAJS_ID = Me!Piegadatajs
!PIEGADES_DATUMS = Me!PiegDatums
!SERIJA = Me!ApdrVeids.Column(2)
!AGENT_CODE = ""
!NUMURS = lngTemp
!PAZIME = 0
!OPER_KODS = Forms![Startup]![Operator]
.Update
End With
Next lngTemp
I can't use
For lngTemp = Polises_No To Polises_Lidz Step 1
With rstApdrXX
.Edit
!IZSNIEGSANAS_DATUMS = Me!IzsnDatums
!SANEMTS_NO_AGENTA = Null
!AGENT_CODE = Me!Agents
!PAZIME = 1
!OPER_KODS = Forms![Startup]![Operator]
.Update !!!!!!!!!!!!!!!!! this record has been changed by
another user since you started editing it ?????
.MoveNext
End With
Next lngTemp
Help me pleaseeeeeeeeeee!!!