Adding text to forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I'm a newbie to Access would like to know if it is possible for a user to
append data to a text field in a form without being allowed to delete
previous data entries.

I.E if a member of staff records an incident another member of staff can add
to this without overwriting the first entry and other members of staff can
add to this entry etc etc

If so would this be easy to implement and are there any examples or add-ons
available?
 
Hi
I'm a newbie to Access would like to know if it is possible for a user to
append data to a text field in a form without being allowed to delete
previous data entries.

I.E if a member of staff records an incident another member of staff can add
to this without overwriting the first entry and other members of staff can
add to this entry etc etc

If so would this be easy to implement and are there any examples or add-ons
available?
Click to expand...

This wouldn't be hard for a programmer. This is the way I would do
it; I would unbind the form and controls from the table, develop
routines to open the table and display the records, and add a Comment
button that would run code to create a new message. I would use one
of the fields in the table to reference the previous message (if there
is one) or give it a unique number if it is the first. That way a
simple index can be used to bring up all of the related messages in
order.

I don't know of any add-ons that do this.
 
Thanks for the reply, very helpful.

Now that I know that it can be done all I've got to do is find a VBA
progammer.
 
Another option would be to have a Comments table. Each comment would be a
separate record and you could include a date/time field. You could then
include a subform (continuous form view) for comments that had its
AllowAdditions property set to True and its AllowEdits property set to False.

Steve
 
Thanks Steve, again very helpful

That sounds logical to me (now that you've outlined the strategy) ... and I
may even give that a try myself - great.
 
Hi
I'm a newbie to Access would like to know if it is possible for a user to
append data to a text field in a form without being allowed to delete
previous data entries.

I.E if a member of staff records an incident another member of staff can add
to this without overwriting the first entry and other members of staff can
add to this entry etc etc
Click to expand...

If you're talking about storing multiple independent comments in one Memo
field (not Text, you'ld run out of the 255 byte size limit real quick)...
Don't.

Follow Steve's advice and create a related Comments table, with one *record*
per comment, rather than jamming all the comments in one field.

John W. Vinson [MVP]
 
Back
Top