Adding text to forms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kevin W - 13 Jul 2007 12:02 GMT

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?

Signature

Thanks in advance
Kevin W

Reply to this Message

OldPro - 13 Jul 2007 14:21 GMT

> Hi
> I'm a newbie to Access would like to know if it is possible for a user to
[quoted text clipped - 11 lines]
> Thanks in advance
> Kevin W

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.

Reply to this Message

Kevin W - 13 Jul 2007 14:36 GMT

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.

Signature

Thanks
Kevin W

> > Hi
> > I'm a newbie to Access would like to know if it is possible for a user to
[quoted text clipped - 22 lines]
>
> I don't know of any add-ons that do this.

Reply to this Message

SteveM - 13 Jul 2007 14:42 GMT

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 for the reply, very helpful.
>
[quoted text clipped - 27 lines]
> >
> > I don't know of any add-ons that do this.

Reply to this Message

Kevin W - 13 Jul 2007 15:04 GMT

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.

Signature

Thanks
Kevin W

> 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
[quoted text clipped - 34 lines]
> > >
> > > I don't know of any add-ons that do this.

Reply to this Message

John W. Vinson - 13 Jul 2007 16:36 GMT

>Hi
>I'm a newbie to Access would like to know if it is possible for a user to
[quoted text clipped - 4 lines]
>to this without overwriting the first entry and other members of staff can
>add to this entry etc etc

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]

Reply to this Message

Kevin W - 13 Jul 2007 17:16 GMT

Thanks John,
I'm getting some useful advice here.

Signature

Thanks
Kevin W

> >Hi
> >I'm a newbie to Access would like to know if it is possible for a user to
[quoted text clipped - 13 lines]
>
> John W. Vinson [MVP]

Reply to this Message