? about closing this popup form

Using A2K. I have a form that allows the user to print one or more
reports. The user checks which report they want printed then they
click on a button to start printing. A popup form displays when they
click on the button and prompts them for a date range. This date
range is then used on each report. (I make the popup invisible when
the range is entered. So it's open during the printing so that the
reports can access the date range.)

After the last report has printed, I want to close the popup form then
redisplay it if the user requests more printing. My problem is that
I'm not sure how to tell when the last report has printed.

Thanks for any help or advice.

re: ? about closing this popup form

Put the following code in the click event of your button:

DoCmd.OpenForm "NameOfDatePopupForm",,,,,acDialog

<<Code to run the selected reports>>

Docmd.Close acForm, "NameOfDatePopupForm"


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
resource@pcdatasheet.com
www.pcdatasheet.com


"Ellen Manning" <manning_news@hotmail.com> wrote in message
news:da7d13b.0402111325.2122b65d@posting.google.co m...[color=blue]
> Using A2K. I have a form that allows the user to print one or more
> reports. The user checks which report they want printed then they
> click on a button to start printing. A popup form displays when they
> click on the button and prompts them for a date range. This date
> range is then used on each report. (I make the popup invisible when
> the range is entered. So it's open during the printing so that the
> reports can access the date range.)
>
> After the last report has printed, I want to close the popup form then
> redisplay it if the user requests more printing. My problem is that
> I'm not sure how to tell when the last report has printed.
>
> Thanks for any help or advice.[/color]

re: ? about closing this popup form

Perhaps you could avoid the problem altogether, by having two unbound
controls on the report form for the user to enter the to and from dates.

Clive


"Ellen Manning" <manning_news@hotmail.com> wrote in message
news:da7d13b.0402111325.2122b65d@posting.google.co m...[color=blue]
> Using A2K. I have a form that allows the user to print one or more
> reports. The user checks which report they want printed then they
> click on a button to start printing. A popup form displays when they
> click on the button and prompts them for a date range. This date
> range is then used on each report. (I make the popup invisible when
> the range is entered. So it's open during the printing so that the
> reports can access the date range.)
>
> After the last report has printed, I want to close the popup form then
> redisplay it if the user requests more printing. My problem is that
> I'm not sure how to tell when the last report has printed.
>
> Thanks for any help or advice.[/color]

re: ? about closing this popup form

Yeah, that sounds like a good suggestion. I'll try that. Thanks.



"CDB" <alpha@delete.wave.co.nz> wrote in message news:<c0eib8$ii1$1@news.wave.co.nz>...[color=blue]
> Perhaps you could avoid the problem altogether, by having two unbound
> controls on the report form for the user to enter the to and from dates.
>
> Clive
>
>
> "Ellen Manning" <manning_news@hotmail.com> wrote in message
> news:da7d13b.0402111325.2122b65d@posting.google.co m...[color=green]
> > Using A2K. I have a form that allows the user to print one or more
> > reports. The user checks which report they want printed then they
> > click on a button to start printing. A popup form displays when they
> > click on the button and prompts them for a date range. This date
> > range is then used on each report. (I make the popup invisible when
> > the range is entered. So it's open during the printing so that the
> > reports can access the date range.)
> >
> > After the last report has printed, I want to close the popup form then
> > redisplay it if the user requests more printing. My problem is that
> > I'm not sure how to tell when the last report has printed.
> >
> > Thanks for any help or advice.[/color][/color]

re: ? about closing this popup form

Sorry, should have been more clear. I tried that but the form closed
before all the reports printed. Therefore I got prompted for the
dates with each report. Thanks for your reply.

"PC Datasheet" <spam@nospam.spam> wrote in message news:<bLxWb.557$hm4.534@newsread3.news.atl.earthli nk.net>...[color=blue]
> Put the following code in the click event of your button:
>
> DoCmd.OpenForm "NameOfDatePopupForm",,,,,acDialog
>
> <<Code to run the selected reports>>
>
> Docmd.Close acForm, "NameOfDatePopupForm"
>
>
> --
> PC Datasheet
> Your Resource For Help With Access, Excel And Word Applications
> resource@pcdatasheet.com
> www.pcdatasheet.com
>
>
> "Ellen Manning" <manning_news@hotmail.com> wrote in message
> news:da7d13b.0402111325.2122b65d@posting.google.co m...[color=green]
> > Using A2K. I have a form that allows the user to print one or more
> > reports. The user checks which report they want printed then they
> > click on a button to start printing. A popup form displays when they
> > click on the button and prompts them for a date range. This date
> > range is then used on each report. (I make the popup invisible when
> > the range is entered. So it's open during the printing so that the
> > reports can access the date range.)
> >
> > After the last report has printed, I want to close the popup form then
> > redisplay it if the user requests more printing. My problem is that
> > I'm not sure how to tell when the last report has printed.
> >
> > Thanks for any help or advice.[/color][/color]