William Hindman
wdhindman at bellsouth.net
Mon Dec 22 14:21:15 CST 2003
...the KB refers to a sample mdb. 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: "Susan Harkins" <ssharkins at bellsouth.net> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Monday, December 22, 2003 2:53 PM Subject: Re: [AccessD] Report's On Open > Well, that's why I asked. It certainly isn't the way I'd go about it and > although I tinkered a little, I didn't get it to work. No matter how I set > the form's properties (modal, popup, both) the report went right ahead and > populated itself -- it just couldn't wait. :) I don't see any way to prevent > it. Course, I was sick and loaded down with meds, so I may not have done a > great job. After a few clicks I put it away -- wasn't work the time. > > Right now I'm stuck on trying to find a field's data type in a closed table > with only the table's name as a string to work with. > > Susan H. > > > > ...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 > > > > > > > > > _______________________________________________ > > 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 >