hzrdc2
asked on
Timestamp in Memo Datatype field access 2010
I thought I saw somewhere that when you create a field with memo datatype, (e.g. Notes)... there was a way that it would set a date/timestamp.
Is this valid? been googling with not much to go on... I would really like it to record the username as well.
Any suggestions would be great!
Is this valid? been googling with not much to go on... I would really like it to record the username as well.
Any suggestions would be great!
hzrdc2,A Memo field is simply a way to store text with 256+ characters.Perhaps if you could post a detailed description of what it is you want to do, then we could be of more assistance :)Patrick
There is no built in way to do this per se.
And are you talking about each time someones adds info to an existing memo?
mx
And are you talking about each time someones adds info to an existing memo?
mx
ASKER
Yeah, Everytime someone logs a note, I would like it to timestamp automatically.
I thought for sure I saw a tutorial on this for 2010.
Maybe I am confused
I thought for sure I saw a tutorial on this for 2010.
Maybe I am confused
you are probably referring to ColumnHistory?
That may be a new feature in A2010 ... does ring a bell.
Otherwise, you would need to code up a scheme for the memo field.
Again, are you talking *each* time someone updates an *existing* memo, and of course a new memo?
mx
Otherwise, you would need to code up a scheme for the memo field.
Again, are you talking *each* time someone updates an *existing* memo, and of course a new memo?
mx
ASKER
Yes, each time... there is a note field. When someone needs to note a record, I would like to see something like this:
[10/22/2010 13:29] - User getting new laptop first part of Q1
[10/18/2010 20:30] - Installed MS Patch KB123456
[10/22/2010 13:29] - User getting new laptop first part of Q1
[10/18/2010 20:30] - Installed MS Patch KB123456
Well, if you are using A2010 (?) then I would look at Column History as suggested above.
mx
mx
COLUMNHISTORY was implemented in A2007
ASKER
looks like its the Append Only field property.. but not sure how it works. Supposed to track history...
you have to set that property Append Only to True
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yeah, this is it:
http://blogs.msdn.com/b/thirdoffive/archive/2006/08/01/684354.aspx
but, pardon my newbieness, but is it possible to get that to print in the note field as explained above?
http://blogs.msdn.com/b/thirdoffive/archive/2006/08/01/684354.aspx
but, pardon my newbieness, but is it possible to get that to print in the note field as explained above?
yes, you can display the content of the memo field in a control in a form..
download the sample file from the link i posted above..
download the sample file from the link i posted above..
ASKER
seems easy enough
=ColumnHistory([RecordSour ce],"Comme nts","[ID] =" & Nz([ID],0))
but it just returns
#ERROR
=ColumnHistory([RecordSour
but it just returns
#ERROR
what is the record source of the form?
ASKER
Yeah, I'm a bone head... just needed to change "comments" to my feild name of "notes"
One problem, it wiped out all my existing notes... good thing I was on a copy.
Would there be a way to change that and NOT have it wipe it all out?
One problem, it wiped out all my existing notes... good thing I was on a copy.
Would there be a way to change that and NOT have it wipe it all out?
you should have set the Append Only field to yes , prior to adding notes..