Printing Multiple reports at one time

  • Thread starter Thread starter Kelly
  • Start date Start date
K

Kelly

I'm sorry about asking this question probably for the 40
millionth time, I have seen this in the newsgroup
questions, but can't find the one answer I needed!

I have 4 reports, I would like to be able to print out
with the touch of 1 button (on toolbar), or one command.

I know there is a macro that can do this, but I don't do
very well with macros, and macros don't like me!!

I have looked at 50+ pages of this newsgroup as well as
the knowledge base, but can't seem to get the hang of
doing this macro!!

I would appreciate the help as I am trying to simplify
this for my mother!!

Kelly
 
Kelly said:
I'm sorry about asking this question probably for the 40
millionth time, I have seen this in the newsgroup
questions, but can't find the one answer I needed!

I have 4 reports, I would like to be able to print out
with the touch of 1 button (on toolbar), or one command.

I know there is a macro that can do this, but I don't do
very well with macros, and macros don't like me!!

I have looked at 50+ pages of this newsgroup as well as
the knowledge base, but can't seem to get the hang of
doing this macro!!

I would appreciate the help as I am trying to simplify
this for my mother!!
Click to expand...

Drop a command button on a form while in design view making sure the wizard
button is depressed. One of the wizard options is to open a report for
preview or print it. After creating a button that prints one of your
reports examine the code that was created. It will look something like...

*****BEGIN CODE***********
Private Sub Command4_Click()
On Error GoTo Err_Command4_Click

Dim stDocName As String

stDocName = "Report1"
DoCmd.OpenReport stDocName, acNormal

Exit_Command4_Click:
Exit Sub

Err_Command4_Click:
MsgBox Err.Description
Resume Exit_Command4_Click

End Sub
*******END CODE************

All you have to do is copy the two lines...

stDocName = "Report1"
DoCmd.OpenReport stDocName, acNormal

....three more times replacing "Report1" with the names of the other three
reports you want printed.
 
Back
Top