|
| 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. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 31st, 2007, 07:34 PM
posted to microsoft.public.access.reports
|
|||
|
|||
limits pages
I have a number of daily reports that I want to limit to one page regardless
of their lenght. How do I page setup/format the reports so I don't have to manually limit it to one page each time I print? 
|
|
#2
August 1st, 2007, 06:42 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
limits pages
You can open the report in preview, print 1 page and close the report
Docmd.OpenReport "ReportName", acViewPreview Docmd.PrintOut acPages ,1, 1 Docmd.Close acReport, "ReportName" -- Good Luck BS"D "sierralightfoot" wrote: I have a number of daily reports that I want to limit to one page regardless of their lenght. How do I page setup/format the reports so I don't have to manually limit it to one page each time I print?
|
|
#3
August 1st, 2007, 04:30 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
limits pages
I can't see that this is working. It doesn't save the print one page setup.
Is there somewhere in report design view I can set it? "Ofer Cohen" wrote: You can open the report in preview, print 1 page and close the report Docmd.OpenReport "ReportName", acViewPreview Docmd.PrintOut acPages ,1, 1 Docmd.Close acReport, "ReportName" -- Good Luck BS"D "sierralightfoot" wrote: I have a number of daily reports that I want to limit to one page regardless of their lenght. How do I page setup/format the reports so I don't have to manually limit it to one page each time I print?
|
|
#4
August 1st, 2007, 11:22 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
limits pages
You can set the report RecordSource to include enough records to print only
one page using TOP Select Top 10 TableName.* From TableName -- Good Luck BS"D "sierralightfoot" wrote: I can't see that this is working. It doesn't save the print one page setup. Is there somewhere in report design view I can set it? "Ofer Cohen" wrote: You can open the report in preview, print 1 page and close the report Docmd.OpenReport "ReportName", acViewPreview Docmd.PrintOut acPages ,1, 1 Docmd.Close acReport, "ReportName" -- Good Luck BS"D "sierralightfoot" wrote: I have a number of daily reports that I want to limit to one page regardless of their lenght. How do I page setup/format the reports so I don't have to manually limit it to one page each time I print?
|
|
#5
August 11th, 2007, 04:22 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
limits pages
Wher do I set this?
"Ofer Cohen" wrote: You can set the report RecordSource to include enough records to print only one page using TOP Select Top 10 TableName.* From TableName -- Good Luck BS"D "sierralightfoot" wrote: I can't see that this is working. It doesn't save the print one page setup. Is there somewhere in report design view I can set it? "Ofer Cohen" wrote: You can open the report in preview, print 1 page and close the report Docmd.OpenReport "ReportName", acViewPreview Docmd.PrintOut acPages ,1, 1 Docmd.Close acReport, "ReportName" -- Good Luck BS"D "sierralightfoot" wrote: I have a number of daily reports that I want to limit to one page regardless of their lenght. How do I page setup/format the reports so I don't have to manually limit it to one page each time I print?
|
|
#6
August 11th, 2007, 06:48 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
limits pages
Open the Report in design view.
Open the report properties (Alt + Enter) In the TAB of the properties select ALL (it might be selected already) Look for the RecordsSource of the report. When the Coursor located in the property you'll see a button with three dots, press it and you'll view the design of the SQL, from the menu select View SQL view If the SQL look like that Select Field , Field2 From TableName Add to it after the select Select TOP 10 Field , Field2 From TableName -- Good Luck BS"D "sierralightfoot" wrote: Wher do I set this? "Ofer Cohen" wrote: You can set the report RecordSource to include enough records to print only one page using TOP Select Top 10 TableName.* From TableName -- Good Luck BS"D "sierralightfoot" wrote: I can't see that this is working. It doesn't save the print one page setup. Is there somewhere in report design view I can set it? "Ofer Cohen" wrote: You can open the report in preview, print 1 page and close the report Docmd.OpenReport "ReportName", acViewPreview Docmd.PrintOut acPages ,1, 1 Docmd.Close acReport, "ReportName" -- Good Luck BS"D "sierralightfoot" wrote: I have a number of daily reports that I want to limit to one page regardless of their lenght. How do I page setup/format the reports so I don't have to manually limit it to one page each time I print?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
