Re: Printing Queries Properties

From: fredg (fgutkind_at_example.invalid)
Date: 04/30/04


Date: Fri, 30 Apr 2004 00:07:35 GMT

On Thu, 29 Apr 2004 23:13:09 GMT, B. W. wrote:

> How do I get Access to retain the print properties I want saved for a
> certain set of queries? No matter how I save it, it seems to revert to
> "regular" paper and "normal" orientation. The program I have set up has 52
> queries, one for each week and I would like to print them all on legal size
> paper with landscape orientation without having to manually change it every
> time.
>
> B.W.

Make a report using the query as record source.
You can save the orientation layout for reports.

52 queries? One for each week? Sounds as though you need to rethink
your database design.

-- 
Fred
Please only reply to this newsgroup.
I do not reply to personal email.


Relevant Pages

  • RE: Query wont report
    ... I went back to begining queries and concatonated and [sanitation ... Jerry Whittle, Microsoft Access MVP ... I also have equipment table and department table linked from ... Now I want to generate a report grouped by location that identifies tasks ...
    (microsoft.public.access.gettingstarted)
  • RE: More line number questions
    ... "Barry" wrote: ... When we linked the original 2 queries and added all the records from ... mimic the old paper report, ... Yes indeed I did change the link in the query to a Left Join. ...
    (microsoft.public.access.reports)
  • Re: Reporting from Queries
    ... survey, check the At Your Survey demo at ... I tried the union query but it only works ... > different tables or queries. ... I want the report to run for only the ...
    (microsoft.public.access.reports)
  • RE: More line number questions
    ... When we linked the original 2 queries and added all the records from ... Those records I am calling fake. ... mimic the old paper report, ... Yes indeed I did change the link in the query to a Left Join. ...
    (microsoft.public.access.reports)
  • RE: Recordset validation in reports
    ... Would there be any problem with having the queries static with all the months ... using calculated fields in the query for each month: ... lookup tables in the database too, ... Report controls adding the month as it goes. ...
    (microsoft.public.access.modulesdaovba)