Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

update query

Discussion in 'Information Technology' started by denelson, Jul 28, 2006.

Tags:
  1. denelson

    denelson
    Expand Collapse
    Guest

    Is there a way to turn off that notice when you run an update query
    that says "Are you sure you want to do this your about to update X
    number of records... blah blah blah"
     
  2. Loading...


  3. Jerry Whittle

    Jerry Whittle
    Expand Collapse
    Guest

    If you are running the update query from a macro or code module, you could
    SetWarnings to No. WARNING: If you set warnings to off at the beginning of a
    macro or module, be very, very sure to turn the warnings back on at the end.
    Otherwise you won't receive other warnings until the database is shut down
    and restarted.
    --
    Jerry Whittle
    Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


    "denelson" wrote:

    > Is there a way to turn off that notice when you run an update query
    > that says "Are you sure you want to do this your about to update X
    > number of records... blah blah blah"
    >
    >
     

Share This Page