A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Print reports with creteria - 2 questions..



 
 
Thread Tools Display Modes
  #1  
Old February 4th, 2010, 07: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
  #2  
Old February 5th, 2010, 01: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



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:01 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.