LinkBack URL
About LinkBacks
Reply With QuoteWelcome to the forum,
With your code why not just open the paste error table
DoCmd.OpenTable "Paste Errors"
This is a discussion on Transferspreadsheet + recd's w/dup'd keys inserted in new table:'Paste Errors' within the Microsoft Access forums, part of the Question Forums category; I am using Docmd.Transferspreadsheet to append a large Access table with a data from an Excel table. Once duplicate values ...
Transferspreadsheet + recd's w/dup'd keys inserted in new table:'Paste Errors'
I am using Docmd.Transferspreadsheet to append a large Access table with a data from an Excel table. Once duplicate values are recognized in any field that should hold unique values I would like to initiate an event that opens a message box that says something like,"Records that Microsoft Office Access was unable to paste have been inserted into a new table called 'Paste Errors.' and have that action performed. Can anyone help me with this?
Last edited by Herbie; Feb 18th, 2010 at 12:35 PM.
Re: Transferspreadsheet + recd's w/dup'd keys inserted in new table:'Paste Errors'
Welcome to the forum,
With your code why not just open the paste error table
DoCmd.OpenTable "Paste Errors"
Trevor
I am on a learning curve of life, I know a little but like to share what I have learnt with others.
I am using Microsoft Office 2003 to 2010
Please remember everyone here is a volunteer, so if you have had a reply to your thread be courteous and acknowledge this.
Posting Permissions
Bookmarks