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
|
|||
|
|||
Rerun query
I have a report based on a query. On opening the report you are prompted to
enter 3 parameters (start date, end date, employee name). I need to run a seperate report for each employee. Is there anyway to code or create a macro that tells the report to reopen with new parameters upon closing or printing. I am trying to avoid opeing the report 80 times. |
#2
|
|||
|
|||
Rerun query
I think an easier way would be to add a Report field in your employee table ,
Yes/No, and use a form with start date & end date in the header and employees listed in datasheet view to check who to use in report. Add a button to run report. -- Build a little, test a little. "Jamie Dickerson" wrote: I have a report based on a query. On opening the report you are prompted to enter 3 parameters (start date, end date, employee name). I need to run a seperate report for each employee. Is there anyway to code or create a macro that tells the report to reopen with new parameters upon closing or printing. I am trying to avoid opeing the report 80 times. |
#3
|
|||
|
|||
Rerun query
Jamie
Just a thought, but if you removed the parameter that prompts for the employee, then modified the report to put each employee's data on a separate page, would that accomplish what you're after? 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. "Jamie Dickerson" wrote in message ... I have a report based on a query. On opening the report you are prompted to enter 3 parameters (start date, end date, employee name). I need to run a seperate report for each employee. Is there anyway to code or create a macro that tells the report to reopen with new parameters upon closing or printing. I am trying to avoid opeing the report 80 times. |
Thread Tools | |
Display Modes | |
|
|