Hello,

I am importing a text file to an existing table with two primary keys. These two preimary keys prevent duplication of records from the text files. I am receiving a primary key violation error. This error allows me to continue and append the records. What I want to do is suppress the error message so the user does not see it. I want the error to default to YES to continue. I believe it is possible to do this within a macro. I know I have seen instructions on this but can't find them now.

Goal: Have the records appended using the primary keys from the table, but defaulting the error message to YES without the user seeing the mesaage. Thanks

GWiz

Look up the SetWarnings method/action.

David R