Action queries

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Coy Howe
    #1

    Action queries

    In tools options you can shut off the Confirm Action Queries. I am
    wondering is there a way to do this with access runtime. So when a
    program is distrubuted the action query confirmation box does not
    appear?


    Thank you,

    Coy

    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Tags: None
    • Allen Browne
      #2
      Re: Action queries

      Try:
      Application.Set Option("Confirm Action Queries"), False

      This is a different setting from SetWarnings, and you may not know about
      engine-level errors that occur when you action queries run. It may be better
      to Execute the query, e.g.:
      dbEngine(0)(0). Execute strSQL, dbFailOnError

      --
      Allen Browne - Microsoft MVP. Perth, Western Australia.
      Tips for Access users - http://allenbrowne.com/tips.html
      Reply to group, rather than allenbrowne at mvps dot org.

      "Coy Howe" <cfs@olypen.com > wrote in message
      news:415c636f$0 $26080$c397aba@ news.newsgroups .ws...[color=blue]
      > In tools options you can shut off the Confirm Action Queries. I am
      > wondering is there a way to do this with access runtime. So when a
      > program is distrubuted the action query confirmation box does not
      > appear?[/color]


        Comment

        • Brenda
          #3
          Re: Action queries


          Thank you for responding, but I have no idea where to put
          Application.Set Option("Confirm Action Queries"), False
          Please give me any additional help you can offer.

          Thank you,

          Brenda


          *** Sent via Developersdex http://www.developersdex.com ***
          Don't just participate in USENET...get rewarded for it!

            Comment

            • Brenda
              #4
              Re: Action queries


              Thank you for responding, but I have no idea where to put
              Application.Set Option("Confirm Action Queries"), False
              Please give me any additional help you can offer.

              Thank you,

              Brenda


              *** Sent via Developersdex http://www.developersdex.com ***
              Don't just participate in USENET...get rewarded for it!

                Comment

                • Allen Browne
                  #5
                  Re: Action queries

                  Place it in the Open event procedure of your startup form, i.e. the form
                  defined under:
                  Tools | Startup

                  --
                  Allen Browne - Microsoft MVP. Perth, Western Australia.
                  Tips for Access users - http://allenbrowne.com/tips.html
                  Reply to group, rather than allenbrowne at mvps dot org.

                  "Brenda" <brenda@mycolle geinfo.com> wrote in message
                  news:415dadd9$0 $26125$c397aba@ news.newsgroups .ws...[color=blue]
                  >
                  > Thank you for responding, but I have no idea where to put
                  > Application.Set Option("Confirm Action Queries"), False
                  > Please give me any additional help you can offer.[/color]


                    Comment

                    Previous template Next
                    Working...