access/vba

[zerocool1]

NVM I got it figured out

I'm writing a query for access in vba.

d_clause = d_clause & " FROM temptbl WHERE ((Not ((temptbl.[description of communication]) Like *Scenario '" & scenariono & "':*) And (temptbl.[description of communication]) Like *scenario*));"

once again a quotations problem.
scenariono is an string that comes from a frame.

can someone help me fix it.

thank you much

Amit

 

[zerocool1]

bump

 

[KLin]

Lots of things wrong. I assume variation is a string also.

w_clause = "WHERE (((Table1.[description of communication]) Not Like '*" & variation & "*') AND (([Trans type].Abbrev) Like '*" & stTrans & "*') AND ((Table1.State) Like '--' Or (Table1.State) Like '*" & stState & "*'));"

 

[zerocool1]

variation is a string literal.

 

[zerocool1]

bump

 

[KLin]

Not should be right before like.

 

[zerocool1]

Originally posted by: KLin
Not should be right before like.

does not seem to be helping. i'm still getting the same syntax error.

 

[Evadman]

Need more info. That statement can be understood a ton of different ways. Assuming the word 'scenariono' is a variable, and you are looking in the 'description of communication' for values that are like '*Scenario ' and the value of the variable 'scenariono' this would do it:

d_clause = d_clause & " FROM temptbl WHERE Not temptbl.[description of communication] Like '*Scenario " & scenariono & "':*' And temptbl.[description of communication] Like '*scenario*'));"