By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,301 Members | 1,741 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,301 IT Pros & Developers. It's quick & easy.

? about closing this popup form

P: n/a
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
Share this Question
Share on Google+
4 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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.