Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
@ automatically creates an InputParameters
To get round this issue I know replace the @ in my sql string with CHAR(64), its a bit messy but works for me. if InStr(1, strSQL, "Like N'@%") > 1 Then strSQL = Replace(strSQL, "Like N'@%", "LIKE CHAR(64) + N'%") Else strSQL = Replace(strSQL, "@", "'+ CHAR(64)+ N'") End If- mileo
- Post #2
- Forum: Microsoft: Access Project (ADP)
-
@ automatically creates an InputParameters
I have a made a DIY QBF form that works fine, some of the items search for contain wildcard characters like % with I deal with by a small bit code that puts [ ] around the characters, then I build the SQl String for the record source of the form. If the @ symbol is being searched for Access...- mileo
- Thread
- Replies: 1
- Forum: Microsoft: Access Project (ADP)
