Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2004
    Posts
    14

    Unhappy Unanswered: Challenge.. auto answer dialog box

    Hi everyone. I need some help with a dialog box. I have a button that users select to update a data set- this button runs an update query. Is there anyway i can get around this dialog box that asks if they want to update 'X' rows etc..? Can I automate the response or make it where access doesn't ask them? Please help.. I have worked my butt off on this project, and this one last thing has been holding me back for almost 2 weeks. Thank you in advance.

  2. #2
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    You can do it two ways. The first way is in Tools-Options-Edit/Find tab In the Confirm group make sure Confirm Action Queries is not set. The other way in code is:

    SetOption "Confirm Action Queries",False
    'Do your query
    SetOption "Confirm Action Queries",True

    I use the second option to make sure it is always turned off when the code is running, but it is turned on when I am doing manual updates/deletes. If you turn it off for the database then you won't see any warnings before you delete records.

  3. #3
    Join Date
    Jun 2004
    Posts
    14

    Thank you!

    Thank you very much man... your help is a life saver! I hope one day i can return the favor!

  4. #4
    Join Date
    Jan 2004
    Location
    The Netherlands
    Posts
    421
    Or use the currentdb.execute "Sql here" statement instead of the docmd.runsql

    Greetz

  5. #5
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    OR

    DoCmd.SetWarnings False
    run SQL Do something
    DoCmd.SetWarnings True

    Don't forget to it on again
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

Posting Permissions

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