[AccessD] Method or Data Member Not Found

The ID fields are numeric.  However, for reasons which I will never be able
to figure out, it suddenly began to work.  

I tried your method actually but put the value into an invisible text box on
the form.  And it went through.  Then, because it was so esthetically
offensive, I put it back to the original syntax and it worked.

Access - ya gotta love it...


Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com
 
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Tuesday, May 20, 2008 5:06 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Method or Data Member Not Found

Rocky,

Is MatterActionID numeric or a string?  What happens if you assign it to a
variable right after the line that succeeds and then use that variable in
your SELECT statement?  Does it still fail?

Charlottte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Tuesday, May 20, 2008 4:59 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Method or Data Member Not Found

The mystery deepens:

This statement goes through:

        MsgBox rstMatterAction!MatterActionID

And two statements later this fails:

        Set rstMatterActionPersons = db.OpenRecordset("SELECT
MatterActionID, PersonID, " _
            & "Hours, SortOrder FROM MatterActionPersons WHERE
MatterActionID = " _
            & rstMatterAction!MatterActionID & " AND " _
            & "(PersonID = " & lngOldAttyMatter & " OR PersonID = " &
Me.AttyMatter.Column(0) & ")")

With !MatterActionID highlighted and saying method or data member not found.
Same datafield in the recordset rstMatterAction.

Does anybody see something I'm overlooking? As I say this OpenRecordset was
copied from another module where it is working.

MTIA


Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com
 
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Tuesday, May 20, 2008 11:13 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Method or Data Member Not Found

Rocky, are you sure you have the object library referenced?

Susan H.
> so you can see that rstMatterAction!MatterActionID is included in the 
> MatterAction recordset.  This code compiles in another module.  So I 
> think that the Data Member Not Found is due to something else.

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

No virus found in this incoming message.
Checked by AVG. 
Version: 7.5.524 / Virus Database: 269.23.21/1455 - Release Date:
5/19/2008
5:04 PM
 

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

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

No virus found in this incoming message.
Checked by AVG. 
Version: 7.5.524 / Virus Database: 269.23.21/1455 - Release Date: 5/19/2008
5:04 PM