[AccessD] OpenArgs question

Heenan, Lambert Lambert.Heenan at AIG.com
Tue Jun 17 08:31:08 CDT 2003


I sit corrected :-) I've not yet had the pleasure (???) of working with
Access beyond  A97.

> -----Original Message-----
> From:	Charlotte Foust [SMTP:cfoust at infostatsystems.com]
> Sent:	Monday, June 16, 2003 5:29 PM
> To:	accessd at databaseadvisors.com
> Subject:	RE: [AccessD] OpenArgs question
> 
> In AXP, reports DO have an OpenArgs parameter.
> 
> Charlotte Foust
> 
> -----Original Message-----
> From: Heenan, Lambert [mailto:Lambert.Heenan at AIG.com] 
> Sent: Monday, June 16, 2003 1:08 PM
> To: 'accessd at databaseadvisors.com'
> Subject: RE: [AccessD] OpenArgs question
> 
> 
> Reports don't have an OpenArgs property, and there is as a result no
> OpenArgs parameter for the OpenReport method. OpenReport does however
> have a "wherecondition" parameter and that's the one you want to use.
> It's a standard SQL WHERE Clause without the word 'WHERE' - see the
> on-line help.
> 
> Lambert
> 
> > -----Original Message-----
> > From:	Susan Harkins [SMTP:harkins at iglou.com]
> > Sent:	Monday, June 16, 2003 4:50 PM
> > To:	AccessD at databaseadvisors.com
> > Subject:	[AccessD] OpenArgs question
> > 
> > This should be an easy one. The following event procedure opens a 
> > report and passes the list box' value as th OpenArgs setting.
> > 
> > Private Sub lstCategories_DblClick(Cancel As Integer)
> >   Dim str As String
> >   str = Chr(34) & Me.lstCategories.Value & Chr(34)
> >   Debug.Print str
> >   DoCmd.OpenReport ReportName:="Catalog", _
> >       View:=acViewPreview, _
> >       OpenArgs:=str
> > End Sub
> > 
> > Problem is, I can't get the report to recognize it -- in any report 
> > event.
> > 
> > Reports!reportname.OpenArgs
> > Me.OpenArgs
> > rpt.OpenArgs
> > 
> > I've tried all three in most of the report's events after opening it 
> > via the form and the setting isn't making it to the form. Any clue 
> > what I'm doing wrong?
> > 
> > Susan H.
> > 
> > _______________________________________________
> > 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