Time and Date stamping

  • Thread starter Thread starter Teri Miller
  • Start date Start date
T

Teri Miller

Would any of you be able to help me with what is probably
an easy task for most of you?

I have a text box in a form that has the data type set
to "memo". I need this large an area because new
information may be added to this text box many times.

I need a way to time and date stamp each and every entry
into that text box and still be able to add more
information at a later date and have that entry time and
date stamped also.

Preferrably, once the entry is stamped, I don't want the
user to be able to change that entry or any before that.

I figure that if this process could be done once the text
box has lost focus, it would work out alright.

Is this too much to ask?

Thanks,
Teri
 
Based on what you want to do, I would suggest not using a single memo field
and instead create a subform linked to a different table with a date field
and a text field.
If you create a sepparate table with 4 fields (LogID, LinkField, date and
LogEntry) you can link the log table to the main table using whatever unique
identifiers tha main table has. When creating the sub-form, link the
"LinkField" (call it what you like) with the unique field from the main
database and you can have a running log with all but unlimited growth. Then
you can allow additions but not edits.

I hope this makes sense. I can visulaize it, but I am sure I am not relaying
it well.
 
Back
Top