Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2002
    Location
    california
    Posts
    31

    Unanswered: record currently locked by another user

    I'm having trouble with a memo field... after I have updated the field, I cannot go back in an update it again... I get a runtime 3188 error that the record is locked. How do I unlock the record? I have had no luck on my searches here or at the KB.
    Thanks in advance for your time and attention.
    Debbie

  2. #2
    Join Date
    Sep 2002
    Location
    california
    Posts
    31
    here is the code that I'm running when I get the error. The frustrating part is that it works for a while and then I get the error. HELP!!!

    Private Sub Command4_Click()

    If newNote.Value = " " Then

    MsgBox "Please enter new message"
    Else

    Me.lastUpdateBy = CurrentUser
    Me.lastUpdateDate = Now()
    OriginalText.Value = (Now() & " - " & CurrentUser & " - " & newNote.Value & "; " & vbCrLf & vbLf & OriginalText.Value)
    DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70
    Me.Requery
    DoCmd.Close
    End If

    End Sub

  3. #3
    Join Date
    Oct 2002
    Location
    NSW Australia
    Posts
    61
    Have you tried doing a me.recalc instead of me.requery ?
    Recalc tends to re-initialise code better for ongoing functions.

  4. #4
    Join Date
    Oct 2002
    Posts
    48

    Add timestamp field in table.

    I have not understand your problem exactly. But try one field in your table Name: Timestampfield, Type: timestamp. It may solve your problem.

Posting Permissions

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