Error number (2000)

Topic

New Reply

Hi,

I would like to know what’s the error number in VB of the following error message:

The changes you requested to the table were not successful because they would create duplicate values in the indes, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.

Also how can I find out the error munber for error message in VB?

Thanks

Regards

Reply | Quote

Replies

Use the following structure as “template” for your code during testing

Sub MyProc()
‘ Declarations
Dim obj As Object

On Error GoTo ErrHandler

‘ Main code
…

ExitHandler:
‘ Clean up
Set obj = Nothing
Exit Sub

ErrHandler:
‘ Report error number
MsgBox Err.Number & ” ” & Err.Description, vbExclamation
Resume ExitHandler
End Sub

This way, you’ll always see the error number.

Reply | Quote

Also check out Error codes (Access XP) from Hans

post 312715

HTH, John

Reply | Quote

Thanks, all. It’s works.

Reply | Quote