Printing Query Results

S

Sheldon Penner

Is it possible to use VBA to run a select query, then send
the results to the printer?
 
F

Fredg

Sheldon,
You can, but you would get more control over appearance, etc. if you just
made the query the recordsource for a report. Print the report.

In any event, to print a query directly, code:

DoCmd.SelectObject acQuery, "QueryName", True
DoCmd.PrintOut

See Access Help for the other arguments available.
 

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

Document won't print 0
Descenders clipped 0
macOS Office365 Word 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Upgraded from Win 7 to Win 10. Publisher printing black. 1
Set up and printing a 4-up mail merged postcard 0
Difficulty with compatibility mode and Track Changes 2
How can I get a Shareable URL via VBA code to a OneDrive image? 0

Top