Help with error 3075 please

[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.

 

[Douglas J. Steele]

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?

 

[MN]

Thanks Douglas.
iThis is work:
strSql = " SELECT * FROM dbo_patient WHERE Soundex(lname) =
Soundex(""Me.lname"") ; "
I do have built in Func Soundex()
Regars

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)

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.