How can I print a query using a command button?

  • Thread starter Thread starter Guest
  • Start date Start date
If you have a question, the place to ask it is here in this big white
space.
Just remember that queries are for record filtering and manipulation,
not for printing.
Create a report, using the query as it's record source,
Print the report.
 
Is there anyway to print the datasheet of the query out using the command
buttons from a form?
 
Is there anyway to print the datasheet of the query out using the command
buttons from a form?
Click to expand...

Look up the SelectObject and the PrintOut methods in VAB help.

To print out a query that is not open:
DoCmd.SelectObject acQuery, "QueryName", True
DoCmd.PrintOut

To print out a query that is already open, change the True to False.
 
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

Opening a query from a command button 2
Command buttons on a datasheet form? 2
Refreshing a query 1
How to use multiple command button to copy user form data to multiple worksheet 0
Command Button 1
Using an Object from a Current form for Criteria in a Query 7
Executing a hidden query 1
using an if statement in a command button? 2

Back
Top