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

    How to get rid of warning message on record delete (Access 2000)

    There's a little Access 2000 app for the internal use, nothing too fancy, but it's important to work automatically. A procedure that keeps track on some external linked tables, which can be changed (this app is char conversion utility built to work on assorted MDBs). So, it's automated to refresh an internal table, and when some records are to be deleted, I get a well known message:

    You're about to delete (n) records....

    And it turns on three times on every linked table, and those can turn to dozens...



    First, I thought that something like VBA/Excel method will do:

    Application.DisplayAlerts = False

    but to no avail, because Access doesn't recognize that method.

    Is there any equivalent to DisplayAlerts or any other way to get rid of those messages?

    Any help is most appreciated!


    Dragan Grbic
    Kikinda, Yu

  2. #2
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to get rid of warning message on record delete (Access 2000)

    DoCmd.SetWarnings False
    ***Your code here****
    DoCmd.SetWarnings True

Posting Permissions

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