Whare is my syntax error... 1

[rbasram]

How to check for syntax errors in the query...I am unable to execute this query it gives me syntax error can someone help. txtTracking is a text box..


str1 = "SELECT * FROM CancelTracking WHERE [Tracking#]= & txtTracking ;"


Thank-you...

 

[jebry]

Hi!

str1 = "SELECT * FROM CancelTracking WHERE [Tracking#]= " & txtTracking & ";"

This assumes that Tracking# is numeric. BTW, I have had a lot of trouble with field names that include # because Access uses the # sign to set off dates.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[cmmrfrds]

str1 = "SELECT * FROM CancelTracking WHERE [Tracking#]= & txtTracking ;"

A couple of things wrong. Anything within the quotes will be treated as text, so you need to resolve the variable before putting it in the string (str1). Also, a text variable must be surrounded by quotes. chr$(34) equals "

str1 = "SELECT * FROM CancelTracking WHERE [Tracking#]= "
str1 = str1 & chr$(34) & txtTracking & chr$(34)

 

[rbasram]

Thanks a lot