Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Aug 2002
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How to suppress warning messages (2K)

    Every time I UPDATE or INSERT I get two warning messages. That's really annoying. Is there any way to suppress them?

  2. #2
    Star Lounger
    Join Date
    Apr 2001
    Location
    Oklahoma City, Oklahoma, USA
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to suppress warning messages (2K)

    I am not sure if this is what you mean, but if you haven't done so you might try going to Tools - Options - Edit/Find and uncheck in the Confirm Box the "Record Changes" Option.

    Jail Administrator Medical

  3. #3
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to suppress warning messages (2K)

    If you are running the queries from code, then you can use

    DoCmd.SetWarnings False

    to turn the warning off before running the query. Then use

    DoCmd.SetWarnings True

    to turn the warnings back on.
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

Posting Permissions

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