Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2008
    Posts
    21

    Unanswered: Updating Memo Field

    I need to update the memo field in the access table. I have unbound form frmNewEntry with two text boxes [txtNewEntry],[txtID] and one command button cmdSave. Usually the user opens the frmNewEntry to add new information when s/he presses cmdSave the content of [txtNewEntry] is added to the memo field [Communications] of the table tblMasterOrders whose record ID equals to the value in [txtID]. Furthermore I need additional information added as well; Current user and time and date with line break as in example shown below.

    4/19/2007 07:15:00 PM,
    joshua,
    Received a call again from a Mr Jack complaining about our products, the complaint escallated to support dpt, waiting for action plan.

    So guys, that is the snag I am facing, your assistance will be highly appreciated.
    Thnx in advance

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    personally I wouldn't implement this as a memo field, I'd do it as a suitable recording each individual contact with the customer.
    the reason..
    well you are at risk of someone editing the data inadvertantly or deliberately
    you loose the ability to enforce data integrity.. you could put a FK on the comment so you could pull up commnet sposted by 'dave', or you loose the ability to see who is handling what,.
    if employee Phyllis usually handles that customer its easy to see.


    id' make a comment record editable when the record is first added.. (or ay within the first 10 minutes it was added (to allow for typos or retyping because the original didn't correctly convey the problem), then I'd lock that record from beeing edited or deleted by anyone except a competant person.

    your child table could automatically set a value of noow() as the date.....

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I agree with Healdem. However, if you must do it like that, you would add something like:

    Me.MemoField = Me.MemoField & vbCrLf & vbCrLf & _
    Format(Now(),"d mmm yyyy at h:nn AMPM") & vbCrLf & _
    GetUsername() & vbCrLf & _
    [txtNewEntry]


    Into the code of the command button.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Apr 2008
    Posts
    21

    Updating memo Field

    Thanks guys,
    I make use of that and will give you feedbak.
    Thanks and Regards

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    You're welcome

    BTW, GetUsername() is a custom designed function. It's well documented around here, probably in the code bank
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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