If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Print Reports
Thanks Steve,
I put four queries like you provide "Between...... and .... " . When I get preview report with four different subforms then I decide to click a print button (toolbox). The result is that i get four times two pop-up box to enter from and to date. Can I do once from the form when entering from date and to date so that it takes care of it all including print button. Your feedback will be much appreciated. Thanks, ******************************** Bill, One approach you might consider is to put two unbound textboxes on your form, and enter your beginning date and end date in these textboxes. Then, in the query that your report is based on, you can refer to these textboxes in the criteria. If I understand you correctly, this will mean something like this in the criteria of your date field in the query... Between [Forms]![YourForm]![DateFrom] And [Forms]![YourForm]![DateTo] -- Steve Schapel, Microsoft Access MVP Bill wrote: Hi, I'm having a problem with printing a report where I click a button "Print Button" on the menu box (top of the screen). When I run the report that connect to four queries and enter Date Range from Beginning to End and got a beautiful report then I decide to print the view report from Menu Button "Print" and it pop up four times from the Queries (Date Rate). I don't understand that I did enter Date Range once before getting a report then print view report and it pops up four times from the queries on the view report after clicking print button. When I select a report and enter Date Range then got a nice report and please help me how to print view report without entering date range. Your help would be much appreciated . |
#2
|
|||
|
|||
Print Reports
Bill,
That's exactly what I meant! However, the form has to still be open, with the dates enterend in the unbound textboxes on the form, at the time that the report is printed. -- Steve Schapel, Microsoft Access MVP Bill wrote: Thanks Steve, I put four queries like you provide "Between...... and .... " . When I get preview report with four different subforms then I decide to click a print button (toolbox). The result is that i get four times two pop-up box to enter from and to date. Can I do once from the form when entering from date and to date so that it takes care of it all including print button. Your feedback will be much appreciated. Thanks, |
#3
|
|||
|
|||
Print Reports
Hi Bill,
I wanted to post a quick note to see if you would like additional assistance or information regarding the information MVP Steve has provided. Thank you for your patience and cooperation and look forward to hearing from you! Sincerely yours, Michael Cheng Microsoft Online Support ************************************************** ********* Get Secure! - www.microsoft.com/security This posting is provided "as is" with no warranties and confers no rights. Please reply to newsgroups only, many thanks. |
Thread Tools | |
Display Modes | |
|
|