Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jul 2007
    Location
    North Carolina, USA
    Posts
    71
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Append history in single feild (2003)

    I have a work log, that tracks the work done by each tech for each work request.
    Currently when they are assigned they have a field (memo type) they enter there information in.
    They requested that they be able to append the data so it shows each update.
    Basically instead of opening the work request and adding to the updates already shown they want to have a blank box to type in and have it append the data to the previous updates upon exit.
    I am not sure how to make text in a text box, add to text in another field. I know how to SetValue on a field but that would wipe out the previous data.
    If you could point me in the right direction I would appreciate it.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Append history in single feild (2003)

    Say that you have a text box txtMyLog to enter data in, and a text box txtMemo that contains the entire log.
    You can put a command button next to txMyLog that will append the text from txtMyLog to txtMemo:

    Private Sub cmdAppend_Click()
    If IsNull(Me.txtMyLog) Then
    MsgBox "You didn't enter any text!", vbExclamation
    Me.txtMyLog.SetFocus
    Exit Sub
    End If
    Me.txtMemo = Me.txtMemo & vbCrLf & Me.txtMyLog
    End Sub

    You can add more info, such as the date/time and/or the username.

    Another option would be to use a separate table for the info, and create a new record for each comment.

  3. #3
    Star Lounger
    Join Date
    Jul 2007
    Location
    North Carolina, USA
    Posts
    71
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Append history in single feild (2003)

    Thanks Hans, I used the code method you provided, vise using another table and it worked out perfectly. As always your assistance was appreciated.

Posting Permissions

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