QueryDef with parameters - item not found (1 Viewer)

dj59 · Jan 24, 2015

I am getting an error.
Item not found in this collection - runtime error 3265.
I've searched online for the answer and I found that it is due to something incorrect in the spelling, etc.
However, I have checked and rechecked.
The query name is qry_55
The field is c.cnty_cd - However this query is run from an sql statement that Has the following from statement:

Code:

....FROM sw_cty_pd AS c

My qryDef code is as follows:

Code:

    Dim db As DAO.Database
    Dim qdf As DAO.QueryDef
    Dim rst As DAO.Recordset
    Set qdf = CurrentDb.QueryDefs("qry_55")
    qdf.Parameters("c.cnty_cd").Value = "01"
    Set rst = qdf.OpenRecordset

Does this need to be written differently because I named the table in the query 'c'?
Thanks for any help on this.

MarkK · Jan 24, 2015

You can check the parameter names with something like . . .

Code:

dim var
for each var in currentdb.querydefs("qry_55").parameters
   debug.print var.name
next

dj59 · Jan 24, 2015

Thank you that showed where my problem was.

jdraw · Jan 24, 2015

It may help others if you tell them what the issue was.

Sharing what you learn is helpful to all.

dj59 · Jan 24, 2015

this code:

Code:

dim var
for each var in currentdb.querydefs("qry_55").parameters
   debug.print var.name
next

showed me the var name. It looked the same as what I had in the code.
I decided to copy the name from the sql and insert it to be certain it was exactly the same. That fixed it. Then I notied that there was no space in the sql where there was a space in my parameter name.

QueryDef with parameters - item not found (1 Viewer)

dj59

Registered User.

MarkK

bit cruncher

dj59

Registered User.

jdraw

Super Moderator

dj59

Registered User.

Similar threads

Users who are viewing this thread