Print

  • Thread starter Thread starter Floyd Forbes
  • Start date Start date
F

Floyd Forbes

Is there anyway to setup a report to just print the first
page only, without using File and print.

Floyd
 
Check the DoCmd's PrintOut method to see if it helps you. It will print the active object,
so if you had a button open a report in preview mode, run the printout command, then close
the report, that should do the trick.

I just tried the following in a button's click event and it worked.

DoCmd.OpenReport "Report1", acViewPreview
DoCmd.PrintOut acPages, 1, 1
DoCmd.Close acReport, "Report1", acSaveNo
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing Reports! 2
PowerPoint Printing PPT to PDF without losing quality 1
Paper size being lost when moving to a different computer 0
Force Report Footing to print at bottom of page 5
How can we convert OST to PDF file format? 1
Report printing multiple pages based on query 2
Page Setup with VBA 1
Epson XP-3150 not printing 2

Back
Top