How do I code this simple expression?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If strFieldName1 contains the word "ThisWord" Then
.....

Thanks for your help.
 
Dear Mike:

If strFieldName1 = "This Word" Then
...code to do something goes here
End If

Or...

But I suspect that your real information need is going to turn out to be a
bit more complicated than this... :)

HTH
Fred Boer
 
Thanks for responding. Is the "=" the operator that I need when the field
contains several words, but I wish to use only one word in the string for the
conditional statement? That is, strFieldName1 contains "ThisWord" but it may
also contain other words.
 
If InStr(1, strFieldName1, "This Word", vbTextCompare) > 0 Then

If you want case sensitivity, use vbBinaryCompare rather than vbTextCompare
 
Thanks Doug,
It's amazing what I've been able to learn and do with that initial code you
gave me as a guide. I'm trying now to look for a word in a particular field,
and then make the value in another field in the same record based upon that
find. For example,
Look for the word "Grooming" in the field "SubCategory" and if it is there
put the word "Grooming" in the field "MainCategory." Otherwise, look for the
word, etc. I want to use the SQL statement "INSERT INTO" but I haven't been
able to get it formatted correctly. I keep getting an 'expected end of
statement' error. Any suggestions?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

populate a ListBox with random strings 3
creating word doc in website 7
findstr question 2
MS word Find and Replace using Regex - Help required 0
simple question but no answer on any access forum! 4
Access Building a IIF expression in Access 0
Calculation/expression stored in a field 7
Where to put code? 2

Back
Top