Check input against a table

[mazdaman]

I’m trying to check the contents of an one field in an Input form that updates my access database. The input form that it want to check field is free text and I want to check this against an abusive terms table in the same database. The abusive terms are just a list of swear words - one in each field in the table. Any ideas – can this be done on the fly – but would rather have a button to click in the management section that I have build to manage the entries

Cheers

 

[onpnt]

sounds like you just need s LIKE clause in your SELECT and tehn validate for EOF

Have you attempted to write anything yet that you may be having problems with?

___________________________________________________________________

http://www.onpnt.com

The answer to your ??'s may be closer then you think.
Check out Tek-Tips knowledge bank by clicking the FAQ link at the top of the page

 

[mazdaman]

Thanks - but a very noice user and yeah got a few projects that i need help with - Can you give me a quick example of the code in context ?

 

[onpnt]

first thing to check on is the LIKE clause in your SQL statement

the next step is to look at some ASP scripting. t his one uses vbscript

you'll need to parse the contents of the user entered values.

more then likely a split on the space between the words try the split() function

hope that helps

___________________________________________________________________

http://www.onpnt.com

The answer to your ??'s may be closer then you think.
Check out Tek-Tips knowledge bank by clicking the FAQ link at the top of the page