Word -> Access SQL statement problems 2

[PerlIsGood]

Can anyone point out the problem/error in the following SQL query?

rst.Open _
  "SELECT * FROM tblClients WHERE [Billing Code] = " & UCase(sClientCode), _
  "Provider=Microsoft.Jet.OLEDB.4.0;" & _
  "Data Source=" & FileLoc & ";"
For Each fld In rst.Fields
  MsgBox fld.Value & ";"
Next

When I remove the WHERE clause it will pull a record from the database, not the one I need, but the code itself works. I just need to figure out how to get the variable into the statement so that I can pull the correct info...

Running the code with the WHERE clause in place I get this error:

Run-time error: 'numbers...
No value given for one or more required parameters

Any help would be greatly appreciated Notorious P.I.G.

 

[SBendBuckeye]

Not sure if this is it, but I think you need single quote tick marks around your clientcode like this:

"SELECT * FROM tblClients WHERE [Billing Code] = '" & UCase(sClientCode) & "'",

Good Luck!

 

[PerlIsGood]

That did the trick. Thx! Notorious P.I.G.

 

[SBendBuckeye]

Generic followup for where clauses:

Strings need single quotes ', dates need pound signs #, if your field names contain embedded spaces you need square brackets []

Examples:

"[Last Name] = '" & yourvar & "'"
"Birthday > #" & yourdatevar & "#"