Results 1 to 9 of 9
  1. #1
    Join Date
    Oct 2005
    Posts
    87

    Delete confirmation msgbox

    Hi there,

    when i press delete button, i get built-in access confirmation msgbox "you are about to delete xx records" or smth like that. But on other computer i don't see it (if i use the same db)..... there should be somewhere in access where i could turn this on or off?

    Where could i turnt it off

    Thanks

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    12,569
    you have probably either
    run a macro and done something like "set warnings off"
    OR
    in your settings disabled warnings
    HTH
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Oct 2005
    Posts
    87
    Quote Originally Posted by healdem
    you have probably either
    run a macro and done something like "set warnings off"
    OR
    in your settings disabled warnings
    HTH

    Thanks, it was in options

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    For the love of god do not turn that off in options.

    I use set warnings false and set warnings true. The second part is kind of important...
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  5. #5
    Join Date
    Nov 2005
    Posts
    26


    Well i have my own msg box for confirm deletion, so double msgboxes was annoying

  6. #6
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Right... "setwarnings false" does a whole lot more than disable sql confirmation messages...
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  7. #7
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    12,569
    If you are that concerned, or insist on putting in your own message box, then consider turning warnings off in code immediately before the step that generates the message box, and off immediately after.

    Failing to do that can cause serious problems with your applciations - precisley the sort of problems that are virtually impossible to debug by remote.
    I'd rather be riding on the Tiger 800 or the Norton

  8. #8
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    Me personally, I use:

    SetOption "Confirm Action Queries", False

    before I run an action query (delete, append, update)

    and then

    SetOption "Confirm Action Queries", True

    I believe it is more specific than turning off all the warnings. The confirmation message will not appear using this command.

  9. #9
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    oooooooooooo.... aahhhhhhhhh....

    good trick, that one gets filed in "Teddy's Bag O' Good Stuff".

    Of course now I have to go rifling through docs to find out what else I can destroy using SetOption...
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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