Disable Paste Errors dialog box

[Matthew Pfluger]

I wrote a Forms event to trap an individual Past Error and suppress its
dialog box, but Access still displays the dialog "Do you want to suppress
further error messages...". I want to disable this box from appearing at
all. I tried SetWarnings option, and that didn't work. Is there another
setting I can use?

Thanks,
Matthew Pfluger

 

[Allen Browne]

To just ignore the errors, import your records programmatically with
Execute, but without using dbFailOnError.