Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2007
    Location
    Olympia, WA
    Posts
    3

    Records deleted with NO warning message.

    I have a form that will delete records with no warnings. I have looked everywhere and can't find whatever setting it is that is disabling warnings for this form only. I have checked my code everywhere for a possible instance of "docmd.setwarnings false"... without out a "docmd.setwarnings true" immediately following - but there is no place in my code that disables the warnings and doesn't turn them back on.
    Any ideas where i could find a setting that would cause the warnings to be disabled?

    Thank you,
    Evan

  2. #2
    jya is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2007
    Location
    Chicagoland
    Posts
    109
    The only place I know of would be under 'Tools', 'Options', and the 'Edit/Find' tab. There is a 'Confirm' section and includes deletions. It may be unchecked.

  3. #3
    Join Date
    Dec 2007
    Location
    Olympia, WA
    Posts
    3
    I've checked all the normal settings but still can't find the problem.
    But I have found a way to make it work for a short time:
    The problem comes and goes, and it seems to be SOOO weird, I wonder if anybody can figure this out...?
    Access is supposed to run the delete events in this order:

    BeforeDeleteConfirm
    AfterDeleteConfirm
    Delete

    But it is skipping the 1st 2 events and going directly to Delete

    Here's the weird part:
    If I add a break-point somewhere in the delete event (but don't change any code), the next time I delete a record there is no confirmation - but the second time I delete, suddenly the Before and After delet confirm events are triggered!!! My delete confirmation is back.
    And it stays back as long as I still have a break point in the Delete event.
    As soon as i remove the break point, (actually the time after that), Access starts skipping the Before and After events again!

    This is too weird for me - does anyone have any idea of what is happening here? Nothing in the code is changing - i'm just toggling a breakpoint!

    Thank you,
    Evan

Please reply to this thread with any new information or opinions.

Similar Threads

  1. FROM Clause error message
    By skylite in forum Queries
    Replies: 2
    Last Post: 10-23-2008, 05:47 AM
  2. Security Warning
    By mojo53777 in forum Security
    Replies: 0
    Last Post: 11-16-2007, 06:23 AM
  3. If / Then Error Message
    By Schwagr in forum Forms
    Replies: 4
    Last Post: 03-30-2006, 06:28 AM
  4. Inserting Picture in MS Access Message
    By wasim_sono in forum Programming
    Replies: 0
    Last Post: 01-17-2006, 03:46 AM
  5. Creating a *Good* Custom Message Box
    By Jerimiah33 in forum Forms
    Replies: 1
    Last Post: 11-09-2005, 04:47 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums