[AccessD] Report's On Open

YOU take a look.<G>  That applies to Access 2000 and doesn't suggest the
report opening a form to filter itself!   Access 2002 reports also have
popup and modal properties like forms.  It could get a little sticky
having a popup form come up over a modal report. <VBG>

Charlotte Foust

-----Original Message-----
From: William Hindman [mailto:wdhindman at bellsouth.net] 
Sent: Monday, December 22, 2003 10:22 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Report's On Open


...take a look at KB208529 :)

William Hindman
There are no easy answers, but there are simple answers. We must have
the courage to do what we know is morally right." --Ronald Reagan


----- Original Message ----- 
From: "Charlotte Foust" <cfoust at infostatsystems.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Monday, December 22, 2003 11:07 AM
Subject: RE: [AccessD] Report's On Open


> Susan,
>
> I use it but I haven't done that.  What you could do is to pop up a 
> dialog (i.e., inputbox or modal popup form) to grab info and generate 
> a filter string in the report's Open event.  It wouldn't be too 
> difficult, but the interaction would stop there.  Once you had grabbed

> the information, you would want to close the form/dialog.  I doubt 
> that the author is talking about some kind of interaction with a 
> persistent form opened by the report.
>
> Charlotte Foust
>
> -----Original Message-----
> From: Susan Harkins [mailto:ssharkins at bellsouth.net]
> Sent: Saturday, December 20, 2003 2:32 PM
> To: AccessD at databaseadvisors.com
> Subject: [AccessD] Report's On Open
>
>
> I read about a technique in a fairly new Access 2002 book that you 
> could use a report's On Open event to filter the data. The section 
> didn't give details, it just referred to displaying a "dialog" in the 
> On Open event. Now, I know you can pass criteria via the OpenArgs 
> property, but the author doesn't seem to be talking about this. In 
> fact, the process seems turned around -- the report displaysing the 
> filtering form, not the other way around.
>
> Does anyone actually use the report's On Open event to somehow grab 
> filtering data? I'd like to hear about it if you do. Keep in mind, I'm

> not talking about displaying a filtering form and then passing the 
> criteria via an OpenReport -- I'm talking about opening a report from 
> the Database window and letting the report's On Open event display a 
> filtering form. I don't see how this would be possible -- how would 
> you stop the report from populating while the Open event displayed a 
> form and the user selected options?
>
> 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