Print only first page

[MarionD]

Hi all,

How can I modify this line
DoCmd.OpenReport stDocName, acPreview, , "[gsid]=" & Me.GSID
so that only the first page of the reports prints?


Thanks for the help
Marion

 

[KenHigg]

Did you ever get this to work?

kh

 

[daveUK]

Use the 'DoCmd.PrintOut' command

i.e.

DoCmd.PrintOut acPages, 1, 1, , 1

This should print out one copy of the first page of the report

Viel Glueck

 

[MarionD]

HI ALL
Thanks for the suggestion.

My problem was this:
I have a report set up to print one page for each "GSID".
To do this I had the Reprt Title in the page header and a page brea in the Groupfooter.
When I printed for all it was fine, but printing for only one GSID, I always got a second page with only the Rpoert title in the page header.


I solved it like this:
I removed the Page break in the group footer, then forced a page break in code, if not printing from a certain form. (I start a multiple run from one form and a single GSID from another form)

In the On Open event of the Report I
If isloaded("Gesamtübersicht") Then
Me.Gruppenfuß0.ForceNewPage = 0
Else
Me.Gruppenfuß0.ForceNewPage = 2
End If

Dankeschön und weiterhin eine schöne Tag!