How to print multiple records

[Julius]

Good day, can someone help me out. I need a very simple solution. How do I
print multiple records from one Print command button. My Quality Specialist
create audit forms some up to 50 records. There is a print command button
that is attached to the report that has mirrors the information on the
record. So if there is 50 records, there are 50 reports, how do I print all
50 reports without going to one record at a time. Hope this makes sense. I
really need this like yesterday. Thank you so much for your help in advance.

 

[Evi]

Don't know what an Audit form is but it must be based on a query - possibly
filtered.

Base your report on the same query.

Group the report (by the Primary Key number if you have to) using the
Sorting Grouping button. Choose to have the Group Footer.
Click on the Group Footer, click on Properties. Next to ForceNewPage, choose
After Section.

Evi

Good day, can someone help me out. I need a very simple solution. How do I
print multiple records from one Print command button. My Quality Specialist
create audit forms some up to 50 records. There is a print command button
that is attached to the report that has mirrors the information on the
record. So if there is 50 records, there are 50 reports, how do I print all
50 reports without going to one record at a time. Hope this makes sense. I
really need this like yesterday. Thank you so much for your help in

advance.

 

[Julius]

Not sure what you are asking me to do. The form is based on a query. No
problem there. Let me reexplain. I work for a Call Center, My department is
responsible for auditing our Customer Service Reps to ensure they are giving
good information to the members etc. You know when you hear "this call will
monitored for quality purposes" that is what we do. Anyway. I created a
form to track those calls, these are call audits. there is a command button
on the form that allows the specialist to print reports based on the
information on the forms. Now you know how access works, you can create a
million records based on that one form without having to close out the form.
What I want to do is create a print all command button that will print all
the reports associated with each record. instead of having to go to the next
record hit print, next record hit print, next record hit print. I set
something up that gives me print all, but it prints the forms, I don't want
the forms I want the reports to print. There is only one report used as a
shell. It only populates one you create a new record and hit print report.
How do I create a print all button that will bring all the record reports.

 

[Evi]

You say

"What I want to do is create a print all command button that will print all

the reports associated with each record. "

ie you say you have 1 record and multiple reports

Then you say
"There is only one report used as a shell.
It only populates one you create a new record and hit print report. "

Here you seem to be saying that you have only 1 report and (perhaps) want to
print multiple records.

I presumed you had added a Command button to the form and, with the help of
the Wizard, chosen to have it Print a report (ie Open it in Normal View) .
If yes, what is the code behind the button (ie open the form in Design View
and click the Code button on the Toolbar)

Or, do you just mean that you are opening your report and then hitting the
Print button on the Menu toolbar

Please clarify what you mean. Once we know what you want, we can help you

Evi

 

[Julius]

Mmmmm, many apologies if I am confusing you with both my replies. So lets
start all over. First here is the code that you requested

stDocName = "Call Profile - Individual Call Dental"
DoCmd.OpenReport stDocName, acPrintAll

Next, there is only one report called "Call Profile - Individual Call
Dental" This report is a shell or template each time a record is created, the
user hits the print button. The data inthe record (better known as a form)
is put in this report. Are you familiar with merging in word, if so lets
look at it like that. each record is a mailing address, and the letter is
the report. You have 15 mailing adddress (records) and 1 standard letter
(report) when you merge the data you now have 15 letters. when you hit the
print button you want to print all 15 letters. I pray that I did not confuse
you any more. that is my goal everything is already put together when I hit
the print button I want to print all the reports as oppose to one at a time.

 

[Evi]

That's a bit clearer now Julius.
Yes, I am more than somewhat familiar with mailmerge.

I think our communication problem is arising because you are using
terminology in an ambiguous manner.
All Access reports are to a certain extent, templates but there is nothing
in the code you supplied to suggest that it is being populated in any way
that is out of the ordinary so perhaps there is something in the Report's On
Open Event. The code you gave just opens the report unfiltered.

Does the query on which the report is based have a parameter link to the fom
which contains the button which you are clicking?

If yes, then you need to change the Sql in the report's Record Source so
that it no longer contains this parameter or - if you want to keep the
current report as is (a very good idea), copy paste it and its source query,
deleting the parameter from the source query.

Then use the Sorting Grouping box as described below to create a page break
between different letters and add a second command button to allow you to
print this second report

Presumably you will need to filter the report in some way so you need to
decide what field you want to filter by, rather than printing all the
records in your database. If the fields are fairly random, you can use a
tick box called Choose and then filter your report by that using your new
command button.

Is this what you want to achieve?

Evi

 

[Julius]

Thank you for your help. It was not what I was looking for I wish you could
see the db but its ok I will continue to work on it thank you very much.