Re: docmd.transfertext

From: RB (robert_at_brokerforce.com.NoSpam)
Date: 10/30/04 

Date: Sat, 30 Oct 2004 08:55:23 -0600

Chuck:

Have you tried "On Error Resume Next"?

Regards,

Robert
"chuck" <chuck@serverking.net> wrote in message
news:oVAgd.6156$kM.1286@newsread3.news.pas.earthlink.net...
>I use docmd.transfertext to allow users to archive (and optionally restore)
>rows from several related tables - e.g., ticket hdrs/line
>items/detailnotes/ etc. They click a button, select an archive text file to
>re-import from, and the code implements it with docmd.transfertext - no
>problems, works fine...
>
> UNLESS the rows being re-imported are still in the tables, causing a 2501
> error msg for each table in the relationship that still has the rows docmd
> is trying to re-import (via acImportDelim option). The msgs come from
> docmd, and an on error goto errrtn in VBA code doesn't happen until after
> a 2501 error msg has been displayed for each related table.
>
> I'd like not to burden the user with these 2501 messages and just ignore
> them - does anyione know a way to intercept these docmd msgs, or some way
> to run docmd that tells it not to do this??
>
> Thanks in advance for any assistance.
>
> Chuck

Loading