Is it possible to use VBA to run a select query, then send the results to the printer?
S Sheldon Penner Aug 11, 2003 #1 Is it possible to use VBA to run a select query, then send the results to the printer?
F Fredg Aug 11, 2003 #2 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.
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.
