Error 3265 Item not found in this collection

[dogdays]

I created a recordset using

SELECT * FROM tblHouseholds INNER JOIN tblTemplatePreviousDonorsJack ON tblHouseholds.nHouseholdNumber = tblTemplatePreviousDonorsJack.nHouseholdNumber

The query selected the correct number of rows, but when I try to access any of the fields from the recordset I get error 3265. This includes the field nHouseholdNumber.
Any thoughts?

tia Jack

 

[Dartagnan]

Is the select statement creating a recordset? If so are you then referencing field names from the recordset? If so then make sure the field names you are referencing actually exist.

 

[SydneyGeek]

What code are you using to create the recordset? You could have an issue with the query name, or there could be a glitch elsewhere.

Denis

 

[dogdays]

Good morning Denis:
I solved the problem by specifying all the fields that I wanted retrieved.
householdRecSet is a DAO.Recordset

' create household select
    strHhldQuery = "SELECT "
    strHhldQuery = strHhldQuery & "tblHouseholds.nIdentity,tblHouseholds.nHouseholdNumber,tblHouseholds.nIndividualNumber,tblHouseholds.nCurrentStatus,"
    strHhldQuery = strHhldQuery & "tblHouseholds.tCurrentState,tblHouseholds.nReasonInactive,tblHouseholds.dtDateJoined,tblHouseholds.tInvoiceMonth,"
    strHhldQuery = strHhldQuery & "tblHouseholds.dtDateInactive,tblHouseholds.dtDateUpdated,tblHouseholds.dtExpirationDate,tblHouseholds.nRelationshipType,"
    strHhldQuery = strHhldQuery & "tblHouseholds.bDoNotMail,tblHouseholds.bDoNotCall,tblHouseholds.bDoNotSolicit,tblHouseholds.tAlternateMailingName,"
    strHhldQuery = strHhldQuery & "tblHouseholds.tAddressLine1,tblHouseholds.tAddressLine2,tblHouseholds.tAddressLine3,tblHouseholds.tCity,tblHouseholds.tState,tblHouseholds.tPostcode,"
    strHhldQuery = strHhldQuery & "tblHouseholds.tCountry,tblHouseholds.mComments,tblHouseholds.bSeasonalAddress,tblHouseholds.bBillingAddress"
    strHhldQuery = strHhldQuery & " FROM " & gcstrHouseholdsTableName
    strHhldQuery = strHhldQuery & " INNER JOIN " & gstrTempPreviousDonorsTableName
    strHhldQuery = strHhldQuery & " ON " & gcstrHouseholdsTableName & ".nHouseholdNumber" & " = "
    strHhldQuery = strHhldQuery & gstrTempPreviousDonorsTableName & ".nHouseholdNumber"
    Set householdsRecSet = DBEngine(0)(0).OpenRecordset(strHhldQuery)

It would have been much easier to use SELECT *.

Jack