Run-Time Error 3265 SQL statement 1

[Clarkie001]

Can anyone tell me why I am getting Run Time error 3265 Item does not exist in this collection with the below sql.

Seems to be the last line (in red) that the error falls on, any help would be greatly appreciated

Clarkie


db.QueryDefs("Report_Builder").SQL = "SELECT tblReports.tbl_ID, tblReports.Report, tblReports.Description," & _
" tblDeveloper.Name, tblDeveloper.Contact_No, tblDeveloper.Email, tblOwner.Name, tblOwner.Contact_No," & _
" tblOwner.Email FROM tblOwner INNER JOIN (tblDeveloper INNER JOIN tblReports ON tblDeveloper.tbl_ID" & _
"= tblReports.Developer) ON tblOwner.tbl_ID = tblReports.Owner WHERE (((tblReports.tbl_ID)=" & strID & "))"

 

[mp9]

Just to check, tbl_id is a numeric field, right?

Otherwise you'd need:

...WHERE (((tblReports.tbl_ID)='" & strID & "'))"

http://www22.brinkster.com/accessory/

 

[Clarkie001]

Yeah, tbl_ID is a numeric field. I have tested this sql in a query window and it runs fine, but when I try and execute the change through VB it gives this error???

Nightmare

 

[PHV]

Is Report_Builder an existing query ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Clarkie001]

PHV,

No, that was the issue, noticed it about 10mins after posting...should have been qryReport_Builder.

Thanks for you help.

Clarkie