Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Posts
    1

    Unanswered: Trapping Warning Messages, NOT errors

    I am trying to trap some warning messages that occur when I run Append Queries in code, I know I can disable them with docmd.setwarnings = false, but I would like to trap them so I can count the number of times they occur. Basically I am appending records some of which will not successfully append due to key violations which is fine, I just want to count the number of successful appends. I am appending one row at a time with a loop. These warning messages don't seem to have error numbers like regular run time errors so I was wondering if any one knew of a way to trap them. Any help would be appreciated.

    Brian C. Smith
    St. Louis, MO USA

  2. #2
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    best way would be to run unmatched query from starting recordset to ending recordset and it would tell you what did not make it after the append query

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •