MS Access help

Discussion in 'OT Technology' started by pimphat, Dec 22, 2004.

  1. pimphat

    pimphat hmmm

    Joined:
    Sep 18, 2002
    Messages:
    5,701
    Likes Received:
    0
    Location:
    Australia
    Whenever you have a form delete a record using VBA it always pops up a box asking if you want to delete the record. If you're deleting records from a few tables at once this gets annoying as it pops up every time. Is there any way to stop this?
     
  2. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA
    docmd.setwarnings false

    ..... (delete records)


    docmd.setwarnings true
     
  3. Penguin Man

    Penguin Man Protect Your Digital Liberties

    Joined:
    Apr 27, 2002
    Messages:
    21,696
    Likes Received:
    0
    Location:
    Edmonton, AB
    :eek3: Now that I know that, I have something to do at work tomorrow :bigthumb:
     
  4. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA
    You may want to make a macro that turns them back on in case you error out while they're off. I've wiped out many a record/query/table because the warning messages were off.
     
  5. Penguin Man

    Penguin Man Protect Your Digital Liberties

    Joined:
    Apr 27, 2002
    Messages:
    21,696
    Likes Received:
    0
    Location:
    Edmonton, AB
    My program is immune to errors :squint:
     
  6. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA
    :rofl: :rofl: :rofl: Even if you were perfect, Access isn't
     
  7. Penguin Man

    Penguin Man Protect Your Digital Liberties

    Joined:
    Apr 27, 2002
    Messages:
    21,696
    Likes Received:
    0
    Location:
    Edmonton, AB
    :mamoru:
     

Share This Page