How to create a comment box with time and date stamp in Access

[adnancanada]

I have created a small database to add comments of users who works on it. I should be like facebook comments you just add it new comments come on top and old comments show below with date and time. Can we do in access form I am sure it would be using VBA code. Thanks in advance.



I created a form there's a comment box, a text box below it and a button. When you enter text into the text box and click the button it adds the text to the comment box and time/date stamps it

[aytee111]

What happens to the comments once they are entered? They must be stored on a table somewhere. Add a field to that table with Date/Time type, with a default value of Now(). Then display that field next to each comment, and in the record source for the form sort it by this new field DESC.

You can also add the user, i.e. who entered each comment if you wish.

[June7]

And if you don't want users to edit the value set textbox Locked Yes and TabStop No.

[adnancanada]

What happens to the comments once they are entered? They must be stored on a table somewhere. Add a field to that table with Date/Time type, with a default value of Now(). Then display that field next to each comment, and in the record source for the form sort it by this new field DESC.

You can also add the user, i.e. who entered each comment if you wish.

Yes I want to store all comments.

[June7]

Form is bound to table? What is data structure? Why is button and code needed?

[orange]

How structured do you want the comments to be?
I once had a database (I think it was called jobjar where users could add comments to jobs/tasks)
It used a memo field (not really recommended, but this is for concept only) and when someone had a new comment the process was to
extract the current memo text, add the current date and time to text box , and the username, and the new comment and then concatenate the just extracted text back into the memo field along with necessary vbCrLF.