thanks by the answer is not ok the compiler reported that the runsql command needs an argument consisting of an sql statement!! any idea??
Docmd.RunSQL("select * from award where name = 'Children's book award'")
thanks but still error!! it reports : syntax error(missing operator) in query expression 'name = 'Children's book award".
Pls read it carefully once again:name = 'Children's book award'Use ' not " nor any other operatorAnd read through the following once again:it reports : syntax error(missing operator) in query expression 'name = 'Children's book award". ~~~You've missed sth.,I guess!
Sorry!it reports : syntax error(missing operator) in query expression 'name = 'Children's book award". you have a ' in your sql string. use \' to replace it.
i have read it carefully! i wrote: DoCmd.RunSQL ("select * from award where name = 'Children's book award'")and the compiler report that : syntax error(missing operator) in query expression 'name = 'Children's book award".it is a strange problem and pls help me!!!
the '\' isn't help! the error becomes syntax error(missing operator) in query expression 'name = 'Children\'s book award".
Can anyone help!! it is really urgent without solving this problem i can;t proceed to the next stage!!Pls help!
Try: name = 'Children''s book award'. ~~~ Use '' to replace ' See it.....ok?
i have tried this before, it works ok on sql server but the VBA in Access reported this statement is not a SQL statement which can be executed using Docmd.RunSQL.Pls any more suggestions??
the compiler reported that the runsql command needs an argument consisting of an sql statement!!
any idea??
it reports : syntax error(missing operator) in query expression
'name = 'Children's book award".
not "
nor any other operatorAnd read through the following once again:it reports : syntax error(missing operator) in query expression
'name = 'Children's book award".
~~~You've missed sth.,I guess!
'name = 'Children's book award".
you have a ' in your sql string.
use \' to replace it.
i wrote:
DoCmd.RunSQL ("select * from award where name = 'Children's book award'")and the compiler report that :
syntax error(missing operator) in query expression
'name = 'Children's book award".it is a strange problem and pls help me!!!
the error becomes syntax error(missing operator) in query expression
'name = 'Children\'s book award".
it is really urgent
without solving this problem i can;t proceed to the next stage!!Pls help!
name = 'Children''s book award'.
~~~
Use '' to replace '
See it.....ok?
but the VBA in Access reported this statement is not a SQL statement which can be executed using Docmd.RunSQL.Pls any more suggestions??