[AccessD] Item Not Found In This Collection

Rocky Smolin rockysmolin at bchacc.com
Tue Jun 8 12:10:15 CDT 2010


Well, it's working.  Thanks for the idea.  

Rocky
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Tuesday, June 08, 2010 9:21 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Item Not Found In This Collection

Hi Rocky

I'm out of ideas. I've never seen something similar.

/gustav


>>> rockysmolin at bchacc.com 08-06-2010 17:41 >>>
Gustav:

So I changed the set of the PODetail recordsets from:

'Set rsPODetail = db.OpenRecordset("Select * FROM tblPODetail WHERE fldPOHID
= " & Me.fldPOHID) 'Set rsPODetailNew = db.OpenRecordset("Select * FROM
tblPODetail")

to:

Set rsPODetail = db.OpenRecordset("Select fldPODRevision, fldPODPosted,
fldPODTaxable, " _
    & " fldPODQuantityReceived, fldPODQuantityOrdered, fldPODDateRequired, "
_
    & "fldPODUnitCost, fldPODUOM, fldPODPartDescription, fldPODVendorPart, "
_
    & "fldPODPartNumber, fldPODLineNumber, fldPOHID, fldPODID " _
    & "FROM tblPODetail WHERE fldPOHID = " & Me.fldPOHID)

Set rsPODetailNew = db.OpenRecordset("Select fldPODRevision, fldPODPosted,
fldPODTaxable, " _
    & " fldPODQuantityReceived, fldPODQuantityOrdered, fldPODDateRequired, "
_
    & "fldPODUnitCost, fldPODUOM, fldPODPartDescription, fldPODVendorPart, "
_
    & "fldPODPartNumber, fldPODLineNumber, fldPOHID, fldPODID FROM
tblPODetail")
 
And that works.  But why?

Rocky


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list