Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Feb 2001
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Auto switching confirmation? (97 SR2b)

    Hi again lounge gurus,

    Is it possible to use code to switch off action query confirmation and then switch it back on again?

    For the most part, I like it on, but for one app that performs a bunch of action queries, I would prefer to have it turned off.

    Can it be done in a sub?

    Fanx,
    JP

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Auto switching confirmation? (97 SR2b)

    Add the following code before the code that opens your query

    <font color=blue>DoCmd.SetWarnings False</font color=blue>

    Don't forget to add the following line after the code that opens the query to set warnings back to true

    <font color=blue>DoCmd.SetWarnings True</font color=blue>
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

Posting Permissions

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