Capture Paste Error

P

Paul Schnitzler

I have an app that the users want to paste into subform to speed things up. I
do not allow access to the database window thus they currently can not get to
the Paste Errors table that is created. What I would like to do is let the
error happen but capture it when it happens and then open up a form for them
that point back to the table.

I can not figure out where to capture the error. I can not catch it in the
form error event. Any Ideas? From some research that I did I know it 8511.
The txt that comes up is

Records that Microsoft Access was unable to paste have been inserted into a
new table called '|.'@In the Database window, open the new table to see the
unpasted records.After you fix the problems that resulted in the paste
errors, copy and paste the records from the new table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top