Creating a history message

  • Thread starter Thread starter grant S
  • Start date Start date
G

grant S

Hi,

I am new to Access 2000 and need to create a way of collating all notes in
one field. For example:

Text box1: User inserts comment

Text box2: contains the above, along with all notes ever added in that field

Any help would be much appreciated.
 
Hi,

I am new to Access 2000 and need to create a way of collating all notes in
one field. For example:

Text box1: User inserts comment

Text box2: contains the above, along with all notes ever added in that field

Any help would be much appreciated.
Click to expand...

I'd merely say that this is almost certainly A Very Bad Idea Indeed.

Not only are you storing data redundantly (the same notes twice) but you're
constantly editing a memo field, a good recipe for database corruption!

Could you consider instead having a separate Notes table? This could be
related one to many to your existing table, and have four fields: a link to
the primary key of your table; a NoteDate field, default value =Now(); a
NoteBy field to capture the identity of the person entering the note; and a
memo field for the note itself. You can display this table on your form using
a Subform base on a query sorting the notes in chronological (or reverse
chronological if you prefer) order so you can see all of the notes, and easily
scroll to the most recent one.
 
Hi John,

Thanks for the advise.

P.S. Do you know how to auto populate a field with the computer user? - I
want to avoid having the user adding their name to a field or select from a
list
 
Hi John,

Thanks for the advise.
Click to expand...

Hope it helps. If you really, really insist, it is in fact possible to jam all
the notes into one memo field. I still think it's a bad idea.
P.S. Do you know how to auto populate a field with the computer user? - I
want to avoid having the user adding their name to a field or select from a
list
Click to expand...

See http://www.techonthenet.com/access/modules/username.php or do a Google
search for "access username".
 
Back
Top