Bill Patten
bill_patten at embarqmail.com
Tue Sep 1 17:36:56 CDT 2009
? AccessError(2491) Wow, I sure didn't know about that feature. Thanks, very handy Bill -------------------------------------------------- From: "Heenan, Lambert" <Lambert.Heenan at chartisinsurance.com> Sent: Tuesday, September 01, 2009 12:27 PM To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Subject: Re: [AccessD] Passing OpenArgs to Subreport Just type ? AccessError(2491) in the immediate window to find out. But as Doug has pointed out, the problem is that the parameter is being passed in via the Filter parameter not the OpenArgs one for the OpenReport method. Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo Sent: Tuesday, September 01, 2009 3:23 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Passing OpenArgs to Subreport I don't know what the 2491 error is ??? Have you put some code in the report to trap the openargs value to inspect it? Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of RANDALL R ANTHONY Sent: 01 September 2009 20:08 To: accessd at databaseadvisors.com Subject: [AccessD] Passing OpenArgs to Subreport Howdy peeps, Probably simple answer but I can't find anything to specifically to solve my problem, could it be one of those can't get there from here? A2003. DoCmd.OpenReport sObjName, acPreview, strSvcRegion & "~" & strLocality When it hits the main report, which is just a shell with three subreports, I get the 2491 error. I've created a label to hold the openargs string, but it doesn't even get there. I've tried a couple other things but that just results in the openargs value in the main report to be null. I'm trying to pass report labels to the subreport. TIA. -- 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