Printing several reports from a form


B

Bo Gustafsson

He

I want to print 3 reports after each other from a form i Ms Access XP.
I also want to set the last pagenumber from report1 in report2 .
The problem is when report1 is printed and I start printing report2 it newer
vill be printed
nothing seems to happen.

I have try to do this by start printing report 2 from the event
report1_Close
Private Sub Report1_Close()
DoCmd.OpenReport "Report2", acViewNormal
End Sub

I have also try to go back to my form and start printing report2
Public Sub Print_report2()
MsgBox "Print startad"
If Me!Utskriftsmedia = 1 Then
MsgBox "Print1startad"
DoCmd.OpenReport "Report2", acViewPreview
Else
MsgBox "Print2 startad"
DoCmd.OpenReport "Report2", acViewNormal
MsgBox "Print3 startad"
End If
End Sub

The statement "Print startad" and "Print2 startad" is executed
The statement "Print3 startad" is not executed and report2 is not printed
and nothing seems to happen.



Any help or suggestions is greatly appreciated.
Bo Gustafsson
 
Ad

Advertisements

F

Fons Ponsioen

A possibility could be to make the reports subreports of a
blank main report, this would also resolve the pagenumber
issue.
Hope this helps.
Fons
 
Ad

Advertisements

B

Bo Gustafsson

No I want to print 3 main report and
the problem is when report1 is printed and I start
printing report2 nothing seems to happen and report2 is newer printed.
//Bo
 

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