[AccessD] Report's On Open

...may the grinch haunt your christmas! :)

...the ref was to Susan's original question ...the form opens a report
preview concurrently as it opens and form edits are reflected immediately in
the report preview ...its a different way of doing things I suppose ...got
enough "sticky" issues without adding more :)

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 2:32 PM
Subject: RE: [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
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>