View Single Post
  #2  
Old February 5th, 2010, 12:07 AM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default 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