[AccessD] SourceObject

Charlotte Foust cfoust at infostatsystems.com
Tue Jan 4 14:59:47 CST 2005


That is because they are reports, but you don't need that construction
in the property, which just holds the name of the report object used to
populate the control.

Charlotte Foust


-----Original Message-----
From: Barbara Ryan [mailto:BarbaraRyan at cox.net] 
Sent: Tuesday, January 04, 2005 10:55 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] SourceObject 


Charlotte.... I wondered about that.  But --- my subreport control name
is subrptUPOHP.  If I select the SourceObject for the subreport control
in Design mode (from the drop-down box), all available selections are
prefixed with "report."

Barb Ryan



----- Original Message ----- 
From: "Charlotte Foust" <cfoust at infostatsystems.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Tuesday, January 04, 2005 12:55 PM
Subject: RE: [AccessD] SourceObject


> Hmmn.  I just realized that your subreport control and the name of the
> subreport object may not be the same.   What you want to pass as the
> sourceobject is the name of the subreport itself.  So if you need to 
> resolve that from subreportcontrol.report.name, do it before you pass 
> it.
>
> Charlotte Foust
>
>
> -----Original Message-----
> From: Charlotte Foust
> Sent: Tuesday, January 04, 2005 9:46 AM
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] SourceObject
>
>
> I wouldn't have expected it to work in 97 either.  I believe it should

> be
>
> Me.subrptUPOHP.SourceObject = "subrptUPOHP" & strOption
>
> Charlotte Foust
>
>
> -----Original Message-----
> From: Barbara Ryan [mailto:BarbaraRyan at cox.net]
> Sent: Tuesday, January 04, 2005 9:43 AM
> To: Access List
> Subject: [AccessD] SourceObject
>
>
> After converting an Access 97 database to Access XP, I am encountering

> the following problem:
>
> A report ("rptUnionProposal") contains a subreport ("subrptUPOHP"). 
> There are several versions of this subreport (e.g., "subrptUPOHP", 
> "subrptUPOHPA", "subrptUPOHPB", etc.).  In the Report Open event, I 
> set the SourceObject for the subreport as follows:
>
> Me.subrptUPOHP.SourceObject = "report.subrptUPOHP" & strOption
>
> This has worked fine in Access 97.  In Access XP, however, I receive 
> the error message - 3011 - the Microsoft Jet database could not find 
> object "~sq_drptUnionProposal~sq_dsubrptUPOHP"
>
> Any ideas on what's happening?
>
> Thanks,
> Barb Ryan
> --
> 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
> -- 
> 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



More information about the AccessD mailing list