Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2004
    Posts
    164

    Unanswered: Remove Prompt for Action Query

    Hello,

    I creates a few action queries that are executed by a macro. When you execute the macro it prompts you thru all the steps that the action query is going to perform. For example, if its an update query it will let you know how may records it will update and then you need to click yes or no.

    By any chance is there a way to remove these prompts? I would love to run this macro whithout having to click on yes to all the action queries in the macro.

    All help is appreciated.

    Thanks

  2. #2
    Join Date
    Aug 2007
    Posts
    25
    setwarnings False - will keep you from being prompted to accept all changes.

    If you are asking about running all queries from one single prompt that is a bit more involved. you can do it any number of ways. I find it easiest to create a form or table which holds the value entered for the prompt. Then point all queries at that form or table.
    Last edited by aldankirk; 10-22-07 at 17:10.
    Kirk Wahl
    GM Powertrain SMCO

  3. #3
    Join Date
    Jan 2004
    Posts
    164
    Awsome. I just added a setwarnings action as the first action in the macro and it took care of that issue. Now i don't have to worry about getting these prompts for all the action queries in this particular macro.

    Thank you Again! Works Great!

  4. #4
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,422
    Provided Answers: 7
    Don't forget to turn them back on

    can cause you problem
    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.

  5. #5
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004

    Talking

    Quote Originally Posted by estefex
    Awsome. I just added a setwarnings action as the first action in the macro and it took care of that issue. Now i don't have to worry about getting these prompts for all the action queries in this particular macro.

    Thank you Again! Works Great!
    And yet another way that I really like and can avoid Setting the Warnings to False and True. Here it is:

    Code:
    CurrentDb.Execute "PostJobCharge"
        CurrentDb.Execute "UpdateStockedItems"
    It does the same which you ask and you never see any prompts. PostJobCharge and UpdateStockedItems are both actual queries in my database. And I learned about the CurrentDB.Execute right here in this Forum.

    have a nice one,
    Bud

Posting Permissions

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