"Too few parameters" error - sometimes

  • Thread starter Thread starter PayeDoc
  • Start date Start date
P

PayeDoc

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)="(e-mail address removed)"));

.... 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
 
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.
 
Back
Top