Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002
    Location
    Virginia
    Posts
    16

    Question Unanswered: Force Answer in Message Box

    Ok... so what I'm doing is moving a "deleted" record into another table as an archive. To do this I chose to use an INSERT INTO SQL statement and then follow that with a DELETE statement. The problem is that Access pops up a confirmation message each time asking if I'm sure I want to do this. Is there any way to force an automatic YES response so the user will never see these messages pop up?

    Keep in mind that I am not using an access method to do this, so I can't just include "acSaveYes" as a parameter for that object. I'd greatly appreciate any help!!! Thanks so much!

  2. #2
    Join Date
    Oct 2002
    Location
    Charlotte, NC
    Posts
    45

    Re: Force Answer in Message Box

    Would you not use the following syntax:

    DoCmd.SetWarnings False

    <your delete statement>

    DoCmd.SetWarnings True



    This will automatically bypass Access's confirmation messages.

    --- or is this an access method? I'm not hip on the lingo yet.

    Brian
    Last edited by stratego16; 01-13-03 at 16:07.
    -----

    "How much deeper would the ocean be without sponges?"

  3. #3
    Join Date
    Oct 2002
    Location
    Virginia
    Posts
    16

    Re: Force Answer in Message Box

    Originally posted by stratego16
    Would you not use the following syntax:

    DoCmd.SetWarnings False

    <your delete statement>

    DoCmd.SetWarnings True



    This will automatically bypass Access's confirmation messages.

    --- or is this an access method? I'm not hip on the lingo yet.

    Brian
    That worked perfectly. Thanks for the help.

Posting Permissions

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