Memo Field, with date/time stamp

[mattP]

Ok I have had a good search around the pages and I have found a lot of examples that nearly do what I want but am still having some problems.

Basically I have a DB that monitors escalations I ( and several colleagues) are dealing with, I have a memo field that requires updating with notesa and I want to place a time/date stamp in the notes first almong with the user who entered the data. This cannot overwrite original data in the memo field as I need to keep a rolling history of updates (for future reporting).

I was looking to make the updated notes field as a read only and have an update button on the main form that when clicked would open another form with a text box. Notes would be typed in and then when this for was closed it updates my main notes field with the text and the date time and user stamp.
I am hoping to get the text format as follows:

"Date/Time" "User"

" text"

I have found loads of references to date/time stamping etc but cannot get the above working

Any help would be appreciated, I have already used other bits of help and advice to get my DB up and running and I must say the help I've been given before is superb.

MattP

 

[KenHigg]

Matt, I did something similar to this where I had pop-up form come up when a user needed to add new comments. It ahad a single text box and when the comments were entered, it would append them to the end of the current records memo/comments fld, getting the system time date and nt system user name/id. Also - the comment fld was locked to prevent editing the existing comments, the only way to add comments was through the pop up form.

Make sense?
kh

 

[mattP]

Ken,

Thanks for this, I did accidently post two threads and got a reply on the other thread which works really well.
I now have my bound memo field and have it set to "locked". I then have an unbound text field that I enter the text in and on "after update event" it enters the following code :

Me.MemoField = Me.MemoField & vbCrLf & Now() & vbCrLf & Me.txtMemoAdd
Me.txtMemoAdd = ""

This works really well as I have the two fields on top of each other on the main form and a button with toggle script to switch between the main field and the add field. Default view is the main field and it seems to work really well.
Thanks for your help though

Rgrds

MattP

 

[KenHigg]

Cool. You can also grab the username with something currentUser(), and the current time and have it automatically pasted in with the comments The users really like how this locks the comments from being changed.

Here's how the one I did looks:

kh