? about closing this popup form

[Ellen Manning]

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.

[PC Datasheet]

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
re******@pcdatasheet.com
www.pcdatasheet.com
"Ellen Manning" <ma**********@hotmail.com> wrote in message
news:da*************************@posting.google.co m...

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.

[CDB]

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" <ma**********@hotmail.com> wrote in message
news:da*************************@posting.google.co m...

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.

[Ellen Manning]

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

"CDB" <al***@delete.wave.co.nz> wrote in message news:<c0**********@news.wave.co.nz>...

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" <ma**********@hotmail.com> wrote in message
news:da*************************@posting.google.co m...

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.

[Ellen Manning]

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" <sp**@nospam.spam> wrote in message news:<bL***************@newsread3.news.atl.earthli nk.net>...

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
re******@pcdatasheet.com
www.pcdatasheet.com
"Ellen Manning" <ma**********@hotmail.com> wrote in message
news:da*************************@posting.google.co m...

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.