Professional Web Applications Themes

Delete error message problem - Microsoft Access

Hi there, i have a delete button on my form with the following code: docmd.runcommand.acCmdDeleteRecord When i run the code click delete, i get a message asking if i am sure i want to delete. If i click yes all is good. If i click no, i get an error stating " the run command action was cancelled" How can I prevent this from occuring. I want to be able to cancel the delete if i don't want to delete the record. Regards, Carlee...

  1. #1

    Default Delete error message problem

    Hi there,

    i have a delete button on my form with the following code:

    docmd.runcommand.acCmdDeleteRecord

    When i run the code click delete, i get a message asking
    if i am sure i want to delete. If i click yes all is
    good. If i click no, i get an error stating " the run
    command action was cancelled" How can I prevent this from
    occuring.

    I want to be able to cancel the delete if i don't want to
    delete the record.

    Regards,
    Carlee
    carlee Guest

  2. #2

    Default Re: Delete error message problem

    docmd.setwarnings false

    On Fri, 18 Jul 2003 10:42:47 -0700, "carlee"
    <grantcjinpsection.gc.ca> wrote:
    >Hi there,
    >
    >i have a delete button on my form with the following code:
    >
    >docmd.runcommand.acCmdDeleteRecord
    >
    >When i run the code click delete, i get a message asking
    >if i am sure i want to delete. If i click yes all is
    >good. If i click no, i get an error stating " the run
    >command action was cancelled" How can I prevent this from
    >occuring.
    >
    >I want to be able to cancel the delete if i don't want to
    >delete the record.
    >
    >Regards,
    >Carlee
    Bruce Loving Guest

  3. #3

    Default Re: Delete error message problem

    On Fri, 18 Jul 2003 15:46:38 -0400, Bruce Loving <BRUCELOVINGSCENTS.COM> wrote:
    >docmd.setwarnings false
    >
    Dont forget to turn the warnings back on after the delete, or you will no longer
    receive system messages anywhere in the app.

    DoCmd.SetWarnings False
    DoCmd.RunCommand.acCmdDeleteRecord
    DoCmd.SetWarnings True

    >On Fri, 18 Jul 2003 10:42:47 -0700, "carlee"
    ><grantcjinpsection.gc.ca> wrote:
    >
    >>Hi there,
    >>
    >>i have a delete button on my form with the following code:
    >>
    >>docmd.runcommand.acCmdDeleteRecord
    >>
    >>When i run the code click delete, i get a message asking
    >>if i am sure i want to delete. If i click yes all is
    >>good. If i click no, i get an error stating " the run
    >>command action was cancelled" How can I prevent this from
    >>occuring.
    >>
    >>I want to be able to cancel the delete if i don't want to
    >>delete the record.
    >>
    >>Regards,
    >>Carlee
    Wayne Gillespie
    Gosford NSW Australia
    Wayne Gillespie Guest

Similar Threads

  1. problem with a string error message
    By Anderson11983 in forum Coldfusion - Advanced Techniques
    Replies: 0
    Last Post: May 5th, 11:58 AM
  2. CFFile Problem in MX7 - No Error Message, No Upload
    By floppo in forum Macromedia ColdFusion
    Replies: 2
    Last Post: March 8th, 05:34 PM
  3. Replies: 0
    Last Post: September 21st, 10:36 PM
  4. Replies: 0
    Last Post: September 21st, 10:36 PM
  5. delete forwarding message copy
    By Jean-Louis Vill in forum Linux Setup, Configuration & Administration
    Replies: 3
    Last Post: September 9th, 04:22 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139