how do I hide warning messages in Macros in Access 2007

Discussion in 'Access Macros' started by biggles, Jan 29, 2008.

  1. biggles

    biggles Guest

    when running macros with multiple queries in Access 2007 I currently have to
    answer Yes/No to warning messages ("are you sure you want to run this ?"). In
    Access 2000 this coul dbe turned off with an extra line inside the Macro but
    that doesn't work in 2007. I have been able turn it off for the entire
    appliction on a single PC but when deploying a database to another user who
    only has Access Runtime for example this option isn't available. Is there a
    way of stopping these messages for an entire database or by macro within that
    database like there was in 2003?
     
    biggles, Jan 29, 2008
    #1
    1. Advertisements

  2. biggles

    KARL DEWEY Guest

    Open the macro in design view, insert a new row at top and anothe at bottom.
    Add action 'SetWarnings' - No in the new row at top and 'SetWarnings' - Yes
    in the new row at bottom.
     
    KARL DEWEY, Jan 29, 2008
    #2
    1. Advertisements

  3. biggles

    biggles Guest

    Thank you for your prompt response Karl !
    Unfortunately, in 2007 there is no option "SetWarnings" in the list in
    design view.
    That was the way I used to do it in 2003. Is there a way this option can be
    added by users in design view so that it can be used? It's not allowing
    anything apart from the listed options with the current settings.
     
    biggles, Jan 30, 2008
    #3
  4. Biggles,

    Click the Show All Actions button on the Show/Hide group on the Macro
    Design Tools tab.

    By the way, you don't need to put a SetWarnings/Yes action in the
    macro... the warnings automatically reverts at the end of the macro
     
    Steve Schapel, Jan 30, 2008
    #4
  5. biggles

    biggles Guest

    Steve, you're a star, thank you!

     
    biggles, Jan 30, 2008
    #5
  6. biggles

    Guest

    Geniuis!! This has saved me hours.
     
    , Feb 24, 2013
    #6
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.