docmd.transfertext

From: chuck (chuck_at_serverking.net)
Date: 10/30/04

  • Next message: Harry: "Problem accessing Access DB through ASP" 
    Date: Sat, 30 Oct 2004 00:05:40 GMT

    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

  • Next message: Harry: "Problem accessing Access DB through ASP"
    Loading