How to Print Multiple Reports

G

Guest

I asked this question earlier under subject Emergency Printing. I did not
understand what was being said so I thought I try a different approach. I
work for a call center and I am managing an access database that was designed
and built by someone who is no longer here. I have a Form where we enter data
on customer service reps. at the end of the day I can have anywhere between 5
to 100 records. My question is how can I print multiple reports one after
the other. currently there is a print command button, but it only let's my
user print one record or report at a time. the criteria on the query is as
follows: [Forms]![New Monitor Form]![RecordNumber]. In addition the VB code
is:

Private Sub Command278_Click()
On Error GoTo Err_Command278_Click

Dim stDocName As String

stDocName = "Call Profile2"
DoCmd.OpenReport stDocName, acNormal
can somone help me, this is urgent and I am at a lost. Thanks for your
assistance it is greatly appreciated.
 
G

Guest

I think if you remove the criteria in the query (which states print just this
one record) you will get alle the records. Remember you will get all the
records so also the records that were previously printed. You have to
consider a range of what you want to print. Let's say for instance only the
records with a recordnumber greater then a certain value...

hth
 

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

Top