Error Code Tables

[siskoray]

As a somewhat new member of the VBA arena I am having problems producing the error list table that the Access Help offers to be able to identify error codes and their descriptions. I copy and paste, per the help, and continue to receive a "User Defined Type - Not Defined" message. I have pasted both the procedure example and the function example yet have had no luck.

Any help would be greatly appreciated. Especially if someone would be willing to email be the database with a successful created table with error codes.

Thanks.

 

[siskoray]

Thanks for answering my question. Actually I did use the exact same code but to no avail. I think I might be missing a step. This is what I did. I used the code that you demonstrated and pasted it into a new module. Then I ran it through the debug option and the error message returns.

Thanks.

 

[siskoray]

Pat, I need to revise my last question. I was able to print out the table, but now I have another question on the same subject. One of my goals was to be able to customize an error message, but the one I'm looking for doesn't appear on the code list. Are there other codes?

The one I'm looking for stars with "Miscrosoft Access can't append all the records.... " Basically telling me that the append action query was not able to fully append and # records did not append due to null values, etc...."

Any help is greatly appreciated.