Print report?

J

Jim

Is there a way to print out a report without showing the
print preview in a command button on a form
Thanks in advance,

Jim
 
F

Fredg

Jim,
Do you mean you wish to print the report without previewing it?
DoCmd.OpenReport "ReportName"
or..
DoCmd.OpenReport "ReportName", , ,Where clause here
 
F

Fredg

Jim,
I do believe you are mistaken.
The default argument for OpenReport is acViewNormal.
Only acView Preview or acViewDesign need to be set, otherwise it prints.
DoCmd.OpenReport "ReportName"
sends the report directly to the printer.

To print just the data of a form:
File + Page Setup + Margins
Check the 'Print Data Only' box.
 

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

Print order of TriFold - Publisher 365 0
Office 2010, background images do not appear in print preview nor print 0
Word docs emailed to me are opening blank (greyed screen) in Print Mode 0
Blank Page After Envelope-Label Wizard 5
Office Word JPEG in a document showing but not printing out 0
Page numbering with Merged Document and IF statements 1
Office 2007 Apps - Printing all graphics mirrored - Text Normal 0
Program buttons to create a word document 0

Top