Hi,

I have a query that in some cases faults on "ms access can't append all the records in the append query ..."

when i put on error on the vba code running this query it doesnt catch it as an error.

any ideas how to catch this error so could handle it by code?

Thanks!