View Single Post
  #1  
Old February 4th, 2010, 06:08 PM posted to microsoft.public.access.tablesdbdesign
Alu_GK
external usenet poster
 
Posts: 51
Default 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