Print report to PDF, Excel, etc

Pat Hartman

Super Moderator
Staff member
Local time
Today, 15:23
Joined
Feb 19, 2002
Messages
44,762
This sample shows several options for data selection as well as several options for data output.
Printing a report is simple. Printing a report for a specific client is a little more complicated, Printing a report for every client record in a file requires a VBA Loop, Printing a report for a selected group requires more thought. This sample shows a method that uses a multi-select listbox.

The output to Excel doesn't send a report, it sends the underlying data file. This example shows how to do it if your export query needs different formatting options for dates (for example).
1723927489150.png


1723927597512.png
 

Attachments

Last edited:

Users who are viewing this thread

Back
Top Bottom