Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts

    No warning upon record delete (Ac97 SR2)

    I just noticed that deleting a record does not invoke the standard "you are about to delete 1 record" confirmation dialog when editing a table -- no form or query involved. Issued "docmd.setwarnings true" from the immediate window. No change. Created a new database with one table and one field. Same behaviour.

    Used a second computer and created the same test database. The standard "confirmation" dialog box appeared.

    I can't remember changing a setting anywhere in the Access environment that would cause this to happen on the first computer. What am I overlooking?

    Thanks.
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: No warning upon record delete (Ac97 SR2)

    The only setting I know of in A97 that will change this is DoCmd.SetWarnings or a macro running the SetWarnings action. Are you sure that neither of those occur in your test database?
    Charlotte

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: No warning upon record delete (Ac97 SR2)

    Positive. The only object in this database, except for the msys* tables, is Table1. It has a single field. Powered-up the computer this morning, and the same thing occurred, so it's not some transient thing. Strange....
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: No warning upon record delete (Ac97 SR2)

    In tools, Option, Edit/Find Tab, Confirm Record Changes has to be checked to get messages.
    Francois

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: No warning upon record delete (Ac97 SR2)

    Good catch, Francois. I had forgotten about that setting.
    Charlotte

  6. #6
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: No warning upon record delete (Ac97 SR2)

    So simple...
    thanks very much
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

Posting Permissions

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