Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Access: Confirm Record Changes and Action queries keeps resetting

Discussion in 'Information Technology' started by Pawaso, Jul 28, 2006.

  1. Pawaso

    Pawaso
    Expand Collapse
    Guest

    For some reason the "Confirm" for "Record changes" and "Action queries"
    options keep resetting. I indeed want the confirmation, yet intermittently I
    go into "tools> options> Edit/Find> Confirm" and the boxes are "unchecked"
    again. Anybody know why this keeps happening, or do you know how to prevent
    it from resetting?
     
  2. Loading...


  3. Alessandro Baraldi

    Alessandro Baraldi
    Expand Collapse
    Guest

    Pawaso ha scritto:

    > For some reason the "Confirm" for "Record changes" and "Action queries"
    > options keep resetting. I indeed want the confirmation, yet intermittently I
    > go into "tools> options> Edit/Find> Confirm" and the boxes are "unchecked"
    > again. Anybody know why this keeps happening, or do you know how to prevent
    > it from resetting?


    Are you using RunSQL method...?

    Docmd.SetWarning False
    Docmd.RunSQL "YOUR ACTION QUERIES..."
    Docmd.SetWarning True

    If you use the Execute Method member of Database Object you don't need
    anything else:

    CurrentDb.Execute "YOUR ACTION QUERIES..."

    To uncheck definitivly the "Confirmation" box on Application Database
    is not a good
    idea..., much better disable only on request....

    @Alex
     

Share This Page