471,063 Members | 4,615 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,063 software developers and data experts.

? 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.
Nov 12 '05 #1
4 2452
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.

Nov 12 '05 #2
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.

Nov 12 '05 #3
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.

Nov 12 '05 #4
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.

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by MJEASSOC | last post: by
4 posts views Thread by SteveS | last post: by
3 posts views Thread by thechaosengine | last post: by
1 post views Thread by Tyrone Slothrop | last post: by
3 posts views Thread by =?Utf-8?B?Vk1J?= | last post: by
3 posts views Thread by Mike Hofer | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.