Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2005
    Posts
    196

    Unanswered: Switch off Confirm record changes

    Going to Tools/Options Edit/Find allows you to select or de-select Confirming Record Changes, Document Deletions and Action Queries. In other words, switching off the annoying 'You are about to update X records. Is there anyway you can do this in code so it doesn't only apply to the local machine?
    Cheers

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    set warnings off/on

    not always a good idea in my view as its easy to loose changes
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    action queries?

    use
    dim strSQL
    strSQL = "UPDATE tblWhatever SET blah = nn"
    currentdb.execute strSQL

    ...fast
    ...no set warnings

    izy
    currently using SS 2008R2

  4. #4
    Join Date
    Aug 2005
    Posts
    196
    The setwarnings works fine - many thanks for your help.
    Cheers

  5. #5
    Join Date
    Jan 2007
    Location
    California, USA
    Posts
    520
    Be sure to SetWarnings = True right after you have done the action you did not want to be bothered about. That way, you don't get something happening that you did not expect, but missed it because there was no warning.

Posting Permissions

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