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,
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
personally I wouldn't implement this as a memo field, I'd do it as a suitable recording each individual contact with the customer.
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.....