Prev: Help With SQL
Next: Data Availability - Timing
From: PayeDoc on 6 May 2010 09:38
Hello All

I'm getting a "Too few parameters" error - sometimes - on the following:

Set rstS = CurrentDb.OpenRecordset("select * from [qry bulletin
recipients]")

The odd thing is that, when [qry bulletin recipients] is:

SELECT practices.email, practices.[prac mgr calling name], practices.[prac
name], practices.[20056 EOY]
FROM practices
WHERE (((practices.email)="leslie(a)xyz.org.uk"));

.... there's no error, but when I amend the query to:

SELECT practices.email, practices.[prac mgr calling name], practices.[prac
name], practices.[20056 EOY]
FROM practices INNER JOIN [qry eoy stages] ON practices.[prac name] = [qry
eoy stages].[prac name]
WHERE (((practices.[20056 EOY])="1"));

.... I get the error. Nothing else is changed.

How can this be?

Hope someone can enlighten me.
Many thanks
Les



From: ghetto_banjo on 6 May 2010 14:24
does the query [qry eoy stages] have any parameters? if so, those
parameters need to be resolved first before you open a recordset on
it.
 | 
Pages: 1
Prev: Help With SQL
Next: Data Availability - Timing