Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2004
    Posts
    173

    Unanswered: Suppress Warning Message from RunSql Method

    I'm using the docmd.RunSql method to update a field and I'm wondering if there is a way to suppress the warning it gives that an update is being done.

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    DoCmd.SetWarnings false


    *Remember to set the true after you're done with the sql. It's just good practise.

    Last edited by Teddy; 06-17-04 at 14:32.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004
    Quote Originally Posted by mmbosman
    I'm using the docmd.RunSql method to update a field and I'm wondering if there is a way to suppress the warning it gives that an update is being done.
    Also just so you don't forget to set the warnings back to true afterwards what I use is:
    CurrentDB.Execute "somequery"

    Bud

  4. #4
    Join Date
    Apr 2004
    Posts
    173

    suppress warnings

    Thanks. You RULE.

Posting Permissions

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