Prev: Relationship not producing expected result(s)
Next: One-to-One Table keys
From: Alu_GK on 4 Feb 2010 13:08
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
From: Jeff Boyce on 4 Feb 2010 19:07
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" <AluGK(a)discussions.microsoft.com> wrote in message
news:5E848243-510A-48DE-B2C2-8091CA85058C(a)microsoft.com...
> 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


 | 
Pages: 1
Prev: Relationship not producing expected result(s)
Next: One-to-One Table keys