How to trap a key violation error in Code? 1

[pdupreez]

I use an "insert " sql statement, and sometimes enter data into the table which already exists. No problem if I can trap the Access97 error box that comes up if an append/update error occurs. I cannot however seem to trap the error, even with an "on error" routine. Any Ideas??

 

[rewdee]

You will have to use the RecordsAffected property to check your action queries. Something like:

Private Sub Command0_Click()
On Error GoTo errHandler
    With CurrentDb
        .Execute "INSERT INTO tbl1 (aNumber) Values (6)"
        If .RecordsAffected > 0 Then
            MsgBox "success"
        Else
            MsgBox "Failed"
        End If
    End With
    Exit Sub
errHandler:
    MsgBox Err.Description
End Sub

I hope this helps,
Rewdee

 

[pdupreez]

Hi Rewdee

It works fine, as I can check vs expected affected and actual and report on difference. Great

Thanks
Pieter