Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Mar 2002
    Location
    Ohio, USA
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have a macro that runs an action query (make table) and was wondering how to avoid the "the existing table will be deleted before you run the query, Do you want to continue anyway? yes/no" prompt? I though if I turned off confirm/action queries on the Edit/find tab under options that would go away, but it's still prompting me. Any ideas? Thanks for the help

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You can insert a SetWarnings action with argument No before the OpenQuery action, and a SetWarnings action with argument Yes after it.

  3. #3
    New Lounger
    Join Date
    Mar 2002
    Location
    Ohio, USA
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts
    As always Hans, you did it.

    Thanks again

Posting Permissions

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