How to print the first page of a report

  • Thread starter Thread starter Jay
  • Start date Start date
J

Jay

I have a report that has many pages. How can I print
the first page using vba?
I have been looking around and all looks complicated.
Is there a simple way to do it?
 
I have a report that has many pages. How can I print
the first page using vba?
I have been looking around and all looks complicated.
Is there a simple way to do it?
Click to expand...

Look up the PrintOut method in VBA help.
 
fredg said:
Look up the PrintOut method in VBA help.
Click to expand...


I did that before and found nothing. I will try again.
It must be there somewhere since you refer to it.

I did think up a quick way to do it. I copied and pasted
everything on my first page of the report to the Page Footer
and deleted every thing in the detail section. It worked.
 
Jay said:
I did that before and found nothing. I will try again.
It must be there somewhere since you refer to it.

I did think up a quick way to do it. I copied and pasted
everything on my first page of the report to the Page Footer
and deleted every thing in the detail section. It worked.
Click to expand...


Ok I have it. Fairly easy.
 
Back
Top