Professional Web Applications Themes

After Update - Microsoft Access

On my After Update on a form. I have it populate 2 fields showing who was in there and what time the changes were made. The problem is, after the after update fires, I can no longer navigate to the next record. It seems to lock up. Is there a script that will allow me to continue. Here is the code I used on my After Update... Me.[Datemo] = Now() Me.[Modifiedby] = user...

  1. #1

    Default After Update

    On my After Update on a form. I have it populate 2 fields showing who was in
    there and what time the changes were made. The problem is, after the after
    update fires, I can no longer navigate to the next record. It seems to lock
    up. Is there a script that will allow me to continue. Here is the code I
    used on my After Update...



    Me.[Datemo] = Now()
    Me.[Modifiedby] = user


    Jacob Guest

  2. #2

    Default Re: After Update

    "Jacob" <jacobintermed1.com> wrote in message
    news:Ol1lH%23TTDHA.1324TK2MSFTNGP11.phx.gbl...
    > On my After Update on a form. I have it populate 2 fields showing who was in
    > there and what time the changes were made. The problem is, after the after
    > update fires, I can no longer navigate to the next record. It seems to lock
    > up. Is there a script that will allow me to continue. Here is the code I
    > used on my After Update...
    Use BeforeUpdate.

    Think about it. You are updating a record in the AfterUpdate event. Guess what? The
    event has to fire again now because you made an update. The record is stuck in a
    loop.


    Rick Brandt Guest

  3. #3

    Default Re: After Update

    For time stamp and audit trail data, you should use BeforeUpdate Event. I
    think you will create a non-terminating loop with AfterUpdate for this
    (unless Access picks it up and I have seen cases where my logic was wrong
    and Access picked it up).

    --
    HTH
    Van T. Dinh
    MVP (Access)



    "Jacob" <jacobintermed1.com> wrote in message
    news:Ol1lH#TTDHA.1324TK2MSFTNGP11.phx.gbl...
    > On my After Update on a form. I have it populate 2 fields showing who was
    in
    > there and what time the changes were made. The problem is, after the after
    > update fires, I can no longer navigate to the next record. It seems to
    lock
    > up. Is there a script that will allow me to continue. Here is the code I
    > used on my After Update...
    >
    >
    >
    > Me.[Datemo] = Now()
    > Me.[Modifiedby] = user
    >
    >

    Van T. Dinh Guest

  4. #4

    Default Re: After Update

    You guys rock....Thanks I did not think of it that way and it works just
    fine now.



    "Jacob" <jacobintermed1.com> wrote in message
    news:Ol1lH%23TTDHA.1324TK2MSFTNGP11.phx.gbl...
    > On my After Update on a form. I have it populate 2 fields showing who was
    in
    > there and what time the changes were made. The problem is, after the after
    > update fires, I can no longer navigate to the next record. It seems to
    lock
    > up. Is there a script that will allow me to continue. Here is the code I
    > used on my After Update...
    >
    >
    >
    > Me.[Datemo] = Now()
    > Me.[Modifiedby] = user
    >
    >

    Jacob Guest

Similar Threads

  1. why is the "Adobe Acrobat 6.0.1 Update" message there at the top? -- the update doesn't work
    By john_cummin@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 6
    Last Post: August 5th, 01:51 PM
  2. 3.0.1 update
    By racker9999@adobeforums.com in forum Adobe Indesign Windows
    Replies: 1
    Last Post: July 30th, 11:49 AM
  3. FWD: Use these update
    By conectiva in forum ASP.NET Security
    Replies: 1
    Last Post: October 13th, 07:04 PM
  4. 5.0.7 Update Pack 1 requires SCO Update license?
    By Scott McMillan in forum SCO
    Replies: 0
    Last Post: July 30th, 08:04 PM
  5. Specifying "do not update" values in "additive" UPDATE sprocs
    By Joel Thornton in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: June 30th, 10:27 PM

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