Help with error 3075 please

  • Thread starter Thread starter MN
  • Start date Start date
M

MN

Hi,
i got this syntax error please help :
strSql = " SELECT * FROM dbo_A WHERE soundex(lname) = ' " &
Soundex(Trim(Me![lname])) & " ' "
Thanks you for any reply.
 
What's the description associated with the error? Error 3075 should be
something like "|1 in query expression '|2'.", where 1 and 2 are context
specific.

Have you defined a Soundex function in your application?
 
Thanks Douglas.
iThis is work:
strSql = " SELECT * FROM dbo_patient WHERE Soundex(lname) =
Soundex(""Me.lname"") ; "
I do have built in Func Soundex()
Regars

Douglas J. Steele said:
What's the description associated with the error? Error 3075 should be
something like "|1 in query expression '|2'.", where 1 and 2 are context
specific.

Have you defined a Soundex function in your application?

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


MN said:
Hi,
i got this syntax error please help :
strSql = " SELECT * FROM dbo_A WHERE soundex(lname) = ' " &
Soundex(Trim(Me![lname])) & " ' "
Thanks you for any reply.
Click to expand...
Click to expand...
 
Back
Top