BobRodes, on 18 December 2011 - 12:51 PM, said:

thanks for the link, oh i see, IIF function is an alternative IF then else statement right?

I use If then then statement before like this:

If Text1.Text = "hi" Then
    Text2.Text = "hello"
Else
    Text2.Text = "what?"
End If

but I don't know how to detect a word from the text, like

text1.text = "hi, how are you?"

I just want to detect the word "hi" from the sentence "hi, how are you?"

is that possible?
because if I use the if then statement it will display the false part,

by the way, I wan't to create a chatbot from that, is that possible? or another way to create chatbot more easier?
thanks

(Sorry for my poor explanation/English)

maj3091, on 18 December 2011 - 12:03 PM, said:

thanks for replying, but I don't know that syntax/code can you give me an example to use that? or how to use that syntax/code?
thanks

@all thank you for posting your replies here,

but i think the code:

Adodc1.RecordSource = "DELETE FROM table1"
Adodc1.Refresh

and my code

Adodc1.RecordSource = "delete * from table1"
adodc1.Refresh

is definitely the same right?
or i just misunderstood that codes?

because the same error occurs..

adodc1
Operation is not allowed when the object is closed.

and then

Run-time error '3704':
Application-defined or object-defined error

btw sir bob the error line is pointed at

Adodc1.Refresh

ahmm sir patric, i have an error in that code?

and besides i don't know what's the meaning of your code or how that code runs

what's the reset adodc by the way?
sorry newbie :|