Syntax problem

  • Thread starter Thread starter philhood2
  • Start date Start date
P

philhood2

I keep encountering a syntax problem with the following
code used in an event procedure.

strQuerySQL4 = "SELECT * FROM Results WHERE ([Results]!
[RiderID])= " & rstRideNoChk!RiderID & " ORDER BY HeatID;"
Set rstResults = dbsCurrent.OpenRecordset(strQuerySQL4)


Can anybody tell me what I've got wrong?

Thanks

Phil.
 
Hi Phil

It's hard to say, because you have not given us much to go on.

My first suspicions would be:

1. [Results]![RiderID] is a text field, so the comparison value needs to be
enclosed in quotes

2. rstRideNoChk!RiderID is Null, so you have nothing to the right of your =
sign.

If it's not one of these, set a breakpooint at the Set rstResults... line
and examine the SQL string in the debug window. If you still can't see the
problem, copy it from there and paste it into the SQL window of a new query,
then try to run the query.
 
Hi Phil,

WHERE ([Results]![RiderID])= " & rstRideNoChk!RiderID & " ORDER BY HeatID;"
should be
WHERE ([Results]![RiderID]= " & rstRideNoChk!RiderID & ") ORDER BY HeatID;"
 
Thanks,

Problem sorted.

Phil.
-----Original Message-----
Hi Phil,

WHERE ([Results]![RiderID])= " & rstRideNoChk!RiderID & " ORDER BY HeatID;"
should be
WHERE ([Results]![RiderID]= " & rstRideNoChk!RiderID & ") ORDER BY HeatID;"

"(e-mail address removed)"
Click to expand...
message news:52c101c480b7$0ae16290$a501280a@phx.gbl...
I keep encountering a syntax problem with the following
code used in an event procedure.

strQuerySQL4 = "SELECT * FROM Results WHERE ([Results]!
[RiderID])= " & rstRideNoChk!RiderID & " ORDER BY HeatID;"
Set rstResults = dbsCurrent.OpenRecordset(strQuerySQL4)


Can anybody tell me what I've got wrong?

Thanks

Phil.
Click to expand...


.
Click to expand...
 
Thanks,

Problem sorted.

Phil.
-----Original Message-----
Hi Phil,

WHERE ([Results]![RiderID])= " & rstRideNoChk!RiderID & " ORDER BY HeatID;"
should be
WHERE ([Results]![RiderID]= " & rstRideNoChk!RiderID & ") ORDER BY HeatID;"

"(e-mail address removed)"
Click to expand...
message news:52c101c480b7$0ae16290$a501280a@phx.gbl...
I keep encountering a syntax problem with the following
code used in an event procedure.

strQuerySQL4 = "SELECT * FROM Results WHERE ([Results]!
[RiderID])= " & rstRideNoChk!RiderID & " ORDER BY HeatID;"
Set rstResults = dbsCurrent.OpenRecordset(strQuerySQL4)


Can anybody tell me what I've got wrong?

Thanks

Phil.
Click to expand...


.
Click to expand...
 
Back
Top