I have designed a database to record training sessions I provide for
colleagues within our company and it allows attendees to provide feedback
relating to how they rated that session. However, this field is full of
comments like "You are a fucking idiot" and "That was a heap of shit" which
I find upsetting and hurtful.
Does anyone know a VBA routine which would run before the record was saved,
and take out such comments. If this is not possible, perhaps it could just
put stars in the right place so it only said things like "You are a f*****g
d**k!!! Go shove that course up your sh*t hole".
Any suggestions gratefully received,

Jules

In my most humble opinion, I would not fix this in Access. I would instead:

1. If its meant in humor, take it that way.
2. If it's not, ask supervsiors to deal with it as totally inappropriate.
3. Make them handwrite the responses - why coddle these apes?
4. Make your training better.

Sorry. Just my opinion.


Darryl Kerkeslager



"Julian Flowers" <jules (AT) hotmail (DOT) com> wrote

On Wed, 29 Sep 2004 22:32:13 +0000 (UTC), "Julian Flowers" <jules (AT) hotmail (DOT) com>
wrote:

Uh - I presume this is a joke. You can't possibly believe that a word is less
offensive if it happens to have its vowells replaced with astereisks, and it's
still totally clear what the word is.

Julian,
I am sorry to say that I'd have to recommend you leave the data as it is.
As a former professional database developer/administrator part of my
reputation depended on my client's confidence in the accuracy and
reliability of the data. Businesses make managerial & policy decisions
based on the data in the systems I maintain and develop. If the data can be
called into question then the decisions made based on it can also be
questioned. Having said that, there is a built-in search and replace
function in Access that will find specific words within a table or column of
a table. It's slow but it works. Now, if I were asked to do this I'd
probably burn a CD of the original database so I had a backup in case my
changes turn out to make things worse.

"Julian Flowers" <jules (AT) hotmail (DOT) com> wrote

Hi,

I would suggest removing any text boxes where your attendees can enter
free form comments and use some combo boxes or option controls with
pre-written comments - like: 1 - very good to 10 - this class was so
bad....

Of course, in doing that you want to make sure you offer the full
gamut of possible viewpoints (from Great to Bad/Sickeningly Bad) - not
just a couple of choices like "Almost Great" "Great" "Nirvana" etc..
<g>

JimA


"Julian Flowers" <jules (AT) hotmail (DOT) com> wrote

Julian Flowers wrote:

8)

I have to smile, Jules, and don't take this as being condescending or
anything. But when you are working in n organization that is staffed by
some or many people who wish to communicate that way, you have to learn
to understand their dialect.

Do the course evaluators sit in a computer lab, side by side each other
and do they all know each other well? Then the reason you're getting
those sorts of responses is _exactly_ the same sort of peer group
bonding crap one used to see in high school. That could be part of the
problem - "Hey, Sam, see what I wrote?" <pals side by side giggle>

Be that as it may, I agree with what the other posters said. Don't
change a thing. I've seen hand written class evaluations which can be
just as shocking. You have to realize that you're dealing with a broad
spectrum of people. Some simply have different sensitivities, others
are doing it from the above described peer group interaction, and a
small number are doing it because they are downright nasty individuals.

It takes many kinds to mke up an orgnization and many organizations have
completely different cultures from that those with which you may be more
acustumed to.

You have to adjust to the culture in which you find yourself. Blanking
out words will not help you adjust. 8)

Good luck.

--
Tim - http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto

I sometimes used to see notes fields with stuff like "!@___-1)@@@" going
on for line after line. That was caused by database corruption....


"Julian Flowers" <jules (AT) hotmail (DOT) com> wrote