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 with creteria - 2 questions..
Hello
Access 2003, vista. I have a form, which contains a series of filter and sorting criteria in order to create a work plan for an employee. The filter and sorting criteria form a report with the work plan for the employee. I need to print, from the form, all the reports that relevant for the work plan. The reports are separated and can differ from one another in their structure and name. I have 2 questions – 1st each print opens the specific report (because they differ I need to open then one at a time and not as a whole batch), print it, and then close it. In a workplan of 200 reports this procedure is very slow, and I need to find a solution that works faster. 2nd – The list of reports are based on a basic query that uses dates as a criteria, and from the form itself I send 8 more filter possibilities, and a sorting preferences. How do I print the list that the criteria in the form represent? And how do I send the printout in the same order as should be in the report (so the user won't have to set the order of the report each time he produces a work plan for the current month). ? Thanks !!! -- Alu_GK |
#2
|
|||
|
|||
Print reports with creteria - 2 questions..
I'm not sure I'm understanding ... please correct any misconception in my
paraphrase below: You have multiple reports. You have a single set of criteria. You have employees. You want to see all your reports for an employee, all driven by/based on that set of criteria. If this is accurate, one way to do this might be to create a macro that runs each report, one after another. Each report would need to be based on its own query, but the all the queries could "point" to that form that holds the criteria. Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Alu_GK" wrote in message ... Hello Access 2003, vista. I have a form, which contains a series of filter and sorting criteria in order to create a work plan for an employee. The filter and sorting criteria form a report with the work plan for the employee. I need to print, from the form, all the reports that relevant for the work plan. The reports are separated and can differ from one another in their structure and name. I have 2 questions - 1st each print opens the specific report (because they differ I need to open then one at a time and not as a whole batch), print it, and then close it. In a workplan of 200 reports this procedure is very slow, and I need to find a solution that works faster. 2nd - The list of reports are based on a basic query that uses dates as a criteria, and from the form itself I send 8 more filter possibilities, and a sorting preferences. How do I print the list that the criteria in the form represent? And how do I send the printout in the same order as should be in the report (so the user won't have to set the order of the report each time he produces a work plan for the current month). ? Thanks !!! -- Alu_GK |
Thread Tools | |
Display Modes | |
|
|