CurrentUser() update.

[Antonio]

Is there a way to programattically enter the CurrentUser() (woever that
happens to be) each time an edit is made in one comment field?
Instead of having a seperate table with multiple records for each entry, I
was wondering if something like his could be done:

All in the same comment field (memo data type):
User A clicks on data field and types: Cant locate. But on the "Got Focus"
or "Before Insert", Access inserts the Current User so that the text looks
like "User A - Cant locate." Then, when another user adds text to the same
field, their entry looks like this: "User A - Cant locate. User B - Well you
need to look harder."
In this way you would be able to have a running dialog going in a data field
in one record.
Is this possible?
TIA

 

[Terry Kreft]

Yes it is but it's a stupid idea.

If you have one entry per record in a separate table you can then join them
all together for display purposes in any format you want.
If you have one entry per record in a separate table you can then query that
table to produce any subset of comments that you want.
If you have one entry per record in a separate table you can have as many
entries as you want (up to file size/disk limits)

If you have them all in one field you can display them very easily
If you have them all in one field you can not query them to produce subsets
very easily
If you have them all in one field then you are restricted by the size of the
field

You can do it properly or you can do it stupidly, it's up to you.

 

[Antonio]

Terry,

Thank you for the response. Can you give me an idea of how to accomplish
what I described?

Thanks.

Antonio