New Comment Line and Locking

[Batmancd]

Hello all,

I was wondering if someone can help me, what i am trying to do is the following:

I have form where a person can input a comment and when the leave it, the comment area locks...BUT here is what I am trying to do

When a person enters a comment and leaves the field, the comment is pushed down and is dated and time stapped. So that the next person that looks at the record can read it the posted comment and enter one of their own...

Thank you for your replies,

Batman

 

[boblarson]

You will need two text boxes for this. One to add the new comment with and the second to display the locked comments. So, for the one that displays the comments, you would set the Locked property to YES and if you don't want it to be selectable (i.e. not able to copy it) then you would need to also set the Enabled property to NO.

Next for the second one I would have it so they can input their text and then click a button to commit it. That way they can edit it or change it up to the point that they commit and then in the button's click event (in the VBA window) you would use:

Me.TextBoxThatDisplaysPreviousDataNameHere = Me.TextBoxThatDisplaysPreviousDataNameHere & vbCrLf & vbCrLf & Now & vbCrLf & Me.TextBoxForInputNameHere
Me.TextBoxForInputNameHere = Null

 

[Galaxiom]

I would seriously consider placing the comments in a related table with one record for each comment. This table will have three fields, UserID, Comment and DateTimeStamp. This allows the comments to be rapidly searched by user and timestamp from any level in the database.

They can be displayed in a subform and management is extremely simple. AllowEdits and AllowDeletions are just set to No.

Using a text field will allow 256 characters per comment. Placing all the comments in a single record could overflow this limit and require a Memo datatype. These are best avoided especially if you are routinely appending to them.

 

[boblarson]

I do agree with Galaxiom about that. It would be better to keep those as individual records and it would also enable you to get information back out whereas the other would really not.

 

[Batmancd]

Gentlemen,

Thank you so much I will try this and see if I can get it working. I do apologize for my questions, as I am not as advanced as you but greatly appreciate the help.

 

[Batmancd]

Well I am part way there, though I think that I am configuring something wrong.

I have the two windows, a button to submit, and have a table for the notes.

I can type a message as I want, when I click the submit button the table comes open, and I cannot see anything but one note.

 

[boblarson]

You should have the table for the notes and a separate form for the notes that is based on the table. Then you can insert that as a subform.

 

[Batmancd]

Thank very much for your assistance. Would you mind looking at my database? It is small and I can send it to you. If not I totally understand.