I have forms that are printed based on a query parameter of [enter item number]. There are several of these forms that I would like to print at one time (with one command) making it easier for the user to gather their information at the beginning of the day. I also don't want to lose the ability to print them out individually as we do now. Can someone direct me to a link perhaps that addresses this? I can't seem to find anything when googling. Thank you!
Print multiple forms or reports from one command?
- Thread starter Ms Kathy
- Start date
- Local time
- Today, 10:43
- Joined
- Jul 9, 2003
- Messages
- 17,448
It's not considered good practice to print forms although I think you mean reports.
I'm not a hundred percent sure about what you want as it's not quite clear. Please provide a simple example by way of explanation
I'm not a hundred percent sure about what you want as it's not quite clear. Please provide a simple example by way of explanation
I am printing forms rather than reports (they are not editable and used for viewing data). The "form" was just a vehicle to use to show the data (by query) of everything needed by the operator. Anyway, the forms are printed by, and different based on the, department to give them the information they need for their area. What I'd like to be able to do is have one command button that will print out all these various forms (all based on the item number they select); but I also don't want to lose the ability to print them individually.
- Local time
- Today, 10:43
- Joined
- Jul 9, 2003
- Messages
- 17,448
Well I think you could probably get it to work with forms if you really fancy a challenge however it would be much simpler with a report.
spikepl
Eledittingent Beliped
- Local time
- Today, 11:43
- Joined
- Nov 3, 2010
- Messages
- 6,142
Someone apparently decided to print forms, perhaps not knowing any better, but persisting with it and building on it will bite you sooner or later. Less pain fixing it now, or much more later 
Creating a report from a form can sometime take only seconds. Think about it.
http://www.techrepublic.com/blog/mi...t-an-access-form-to-a-report-before-printing/
Creating a report from a form can sometime take only seconds. Think about it.
http://www.techrepublic.com/blog/mi...t-an-access-form-to-a-report-before-printing/
- Local time
- Today, 10:43
- Joined
- Jul 9, 2003
- Messages
- 17,448
Well, it's not a problem, you will need to write some clever VBA to do it.
With a report, it should be a much simpler process as Reports are designed to handle this type of data.
I checked out that link and see that it is an easy process to change a form to a report; which I will look at doing for all the forms in the database (with the exception of those that really need to be a form). Anyway, I have just 2 questions:
- What happens to a form that it would come back to bite?
- How do I do what I want to do (print multiple reports, now) from a single command?
On that note I will exit to work on the forms/reports. Thank you.
- What happens to a form that it would come back to bite?
- How do I do what I want to do (print multiple reports, now) from a single command?
On that note I will exit to work on the forms/reports. Thank you.
- Local time
- Today, 10:43
- Joined
- Jul 9, 2003
- Messages
- 17,448
You should endeavour to get all of the information into one query. Then have one report based on that query. The report can then print out groups which should match the information you are looking for.
Ok, so I'm working out of a backed-up database copy. I changed four of the forms to reports (by "saving as"). I question how to successfully print all these reports from one query since all of these "reports" are designed VERY differently. I have two of them attached for your reference. I'm unclear how to proceed . . .
spikepl
Eledittingent Beliped
- Local time
- Today, 11:43
- Joined
- Nov 3, 2010
- Messages
- 6,142
You need to learn how to use the resources available - that will serve you much better than me holding your hand. All access functions and methods are described online. Now that is a clue there.
If your reports need parameters then you need to do docmd.openreport first where you can pass the parameter - look up the method. Then while the report is open, you can do docmd.outtputto, where it then will grab the open report with the parameters and output it.
Alternatively, you can rewrite the recordsource of the reports, so that that query incorporates the required parameter, and then you would not have to do the openreport first, because the report output via the docmd.outputto would have the right data. If all this makes no sense (yet) stick to the previous paragraph.
And all of these docmd statements can simply be written one after the other in a command button's On Click handler, so you can execute them by clicking that button. Google access command button.
If your reports need parameters then you need to do docmd.openreport first where you can pass the parameter - look up the method. Then while the report is open, you can do docmd.outtputto, where it then will grab the open report with the parameters and output it.
Alternatively, you can rewrite the recordsource of the reports, so that that query incorporates the required parameter, and then you would not have to do the openreport first, because the report output via the docmd.outputto would have the right data. If all this makes no sense (yet) stick to the previous paragraph.
And all of these docmd statements can simply be written one after the other in a command button's On Click handler, so you can execute them by clicking that button. Google access command button.
Last edited:
If you didn't want to help, why not just say so from the git go?
I obviously don't have the knowledge and expertise that you do. And I have googled and looked at various other websites and links. I came here because I thought this site was a resource as well - where smart people can help out us "other" people. I certainly didn't mean for you to hold my hand.
I obviously don't have the knowledge and expertise that you do. And I have googled and looked at various other websites and links. I came here because I thought this site was a resource as well - where smart people can help out us "other" people. I certainly didn't mean for you to hold my hand.
spikepl
Eledittingent Beliped
- Local time
- Today, 11:43
- Joined
- Nov 3, 2010
- Messages
- 6,142
I did not say that I do not want to help. But I will not retype stuff you can google yourself. I gave you enough clues, and all the access functions are in fact well-described, so no point in me retyping it. But anyhoo, I gave you the recipe, and now , if you do not panic but relax and think, you got enough info to be all right by yourself.
Similar threads
