Help with error 3075 please MN 12/4/2008 3:59:01 PM 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.

Re: Help with error 3075 please "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_gmail.com> 12/4/2008 4:28:19 PM 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 http://I.Am/DougSteele (no private e-mails, please) "MN" <MN[ at ]discussions.microsoft.com> wrote in message news:3C86D8B3-B429-4C28-9A3B-0FC92F9A0EF1[ at ]microsoft.com... [Quoted Text] > 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.

Re: Help with error 3075 please MN 12/4/2008 5:02:01 PM 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" wrote: [Quoted Text] > 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 > http://I.Am/DougSteele > (no private e-mails, please) > > > "MN" <MN[ at ]discussions.microsoft.com> wrote in message > news:3C86D8B3-B429-4C28-9A3B-0FC92F9A0EF1[ at ]microsoft.com... > > 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. > > >