473,240 Members | 1,962 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,240 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 2609
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: MJEASSOC | last post by:
I need some help with closing a popup window. I'm making an online portfolio, that has one base page with text and thumbnails. When a user clicks on a thumb, a new window opens containing a larger...
4
by: deko | last post by:
I have a pop-up form in which user-defined parameters are entered. The parameters are entered into a subform datasheet which is bound to a table. I need to check the product of two parameters to...
4
by: SteveS | last post by:
Hello. This is a strange problem which does not make sense to me. I open a popup page with the following javascript code: function OpenDenyWindow(changeId) {...
3
by: thechaosengine | last post by:
Hi all, I need to be able to cause the following chain of events after clicking an asp:button but I don't know how to do it. I'd really appreciate any advice on this or alternative approaches: ...
4
by: rdemyan | last post by:
I'm using code from the following web page to open the API Browse Folder dialog http://www.mvps.org/access/api/api0002.htm It all works fine. But if the dialog box is open and the user closes...
1
by: Tyrone Slothrop | last post by:
Any idea of why this will not work? I have an image editor in a popup that is opened from a form in a window containing data as well as displaying images for the record. When the image has been...
4
by: Macbane | last post by:
Hi, I have a 'main' form called frmIssues which has a subform control (named linkIssuesDrug) containing the subform sfrmLink_Issues_Drugs. A control button on the main form opens a pop-up form...
3
by: =?Utf-8?B?Vk1J?= | last post by:
How can I close popup window automatically when I close the parent window (the application itself)? Thanks.
3
by: Mike Hofer | last post by:
Okay, here's the situation: we want to be able to display ASPX pages in an UpdatePanel. The reasons for this are performance related. The site in development uses *lots* of modal popups from some...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

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.