Comma in query expression

I have a txt field where I enter names in this format: "last
name"+comma+space+"first name"
(Brady, Tom)

the after update event runs a DCount procedure. I get the Syntax error (comma)
in query expression.
I believe that it is the format of the textfield, but I don't know how to fix
it. Here is the code line where it occurs.

if DCount("*", "Main", "[Name]=" & me.Recipient) <1 Then

The errors is:

Syntax error (comma) in query expression '[Name]=Brady, Tom'.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200709/1

.

Relevant Pages

  • Re: SQL HANGS
    ... that field blank which it can sometimes be then I get a Syntax Error ... in Date Query Expression. ... Any way of fixing this so that I can leave ... It would be better, though, to format date literals into mm/dd/yyyy ...
    (microsoft.public.access.forms)
  • Re: fixed length file to excel? VBA macro possible?
    ... Tom was pointing out that Excel expects every row to be the same, ... Because i need to format the lines that start with say 02 differently ... Dim FileName As String ...
    (microsoft.public.excel.programming)
  • Re: Calling a Function or a Procedure
    ... Which format to use for Sub procedures is a matter of style. ... parameter is ByRef then any changes made to the value in MySub are lost ... The syntax error with multiple arguments comes up because if you try to use ...
    (microsoft.public.vb.general.discussion)
  • Re: Combo box problem
    ... Tom ... > Remove the fixed in the format so that it is blank ... >>> many other words are reserved words in ACCESS, ... >>> List of Microsoft Jet 4.0 reserved words ...
    (microsoft.public.access.forms)
  • Re: Query Help Please! Is a Weekly data format Possible?
    ... Thanks for the reminder, Tom. ... "Tom Ellison" wrote: ... the DatePart function I used will work on a date that is in string ... That is why I asked for the format. ...
    (microsoft.public.access.queries)