Deletion of exsiting comments?

D

Doug_C

Hello all,

Ok, here is a more precise picture of what I am doing. When the use selects
a project and wants to add a comment/status, they click the "Update Status"
button. The button then add - Current Date and Time a "-" and then the cursor
to start typing the comment in the textbox which looks like this:

02/12/05 03:30PM-Some Comment
04/24/05 12:12PM-Some Comment
07/30/05 10:26AM-Some Comment etc.....

The only thing I need to do, is somehow prevent someone from
deleting/editing the previous comments. The honor system isn't working to
well so that is why I need to preserve the previous comments because some
folks have manipulated data. They can add as many comments as they like but I
don't want anyone changing the previous comments made. It seems like it
should be quite simple to do but, it is definitely beyond me. If this can
not be accomplished, please give me some direction as to how I can do this.
Also, as I am a novice, please explain in simple terms how I might defeat
this problem. Any help would be greatly appreciated!!

Thanks to all!!
 
R

Rick B

The only way I could see to do that is to lock the field so the use can't
get to it.

Then change your code. Have an input box pop up to let the user enter the
text they want to add, then (in code) insert that text (plus your timestamp)
into the memo field. Something like..

Another (better option) is to normalize your design. If one "record" can
have multiple comments, then each comment should be stored in a separate
table as a one-to-many relationship to your record table.

tblMain
RecordID
Name
Date
etc.

tblComments
RecordID
DateandTime
UserID
Comment
etc.

Then, you can better control allowing a comment to be added, but not
modified.
 
D

Doug_C

Sounds like an idea. I'll give this a try and also, make the separate table.
Thanks for help Rick, much appreciated!!
 
D

Doug_C

Itried this but when I click add record on the pop up form, it says:"You
cannot add or change a record because a related record is required in table
'tblTopicNames' (which is the name of my main table) I'm not sure what to do
now?
 
Top