limits pages

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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"
 
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?
 
You can set the report RecordSource to include enough records to print only
one page using TOP

Select Top 10 TableName.* From TableName
 
Wher do I set this?

Ofer Cohen said:
You can set the report RecordSource to include enough records to print only
one page using TOP

Select Top 10 TableName.* From TableName
Click to expand...
 
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
 
Back
Top