C
Chip
Hey Everyone...
I did a little searching. My first question is does anyone know if I
can open a subreport in Landscape mode? I have a main report which is
in Portrait view and I want one of the SubReports to be in landscape
(its a table with tallys and lots of numbers).
If thats not possible, I will run the report separately. But, before
I do that, I wanted to ammend the OnOpen code for the first report, to
open the "subreport" as a separate window.... Here is the code for the
OnOpen event for the first report. How would I ammend it to then also
open the second "landscaped" report. Both report take the same
parameters, so they will all get their input parameters from the EOM
Date Parameter form.
Private Sub Report_Open(Cancel As Integer)
'Set publice variable to true to indicate that the report
' is in the Open event
bInReportOpenEvent = True
'Open sales by category dialog
DoCmd.OpenForm "EOM Date Parameters", , , , , acDialog
'Cancel Report if User Clicked the Cancel button
If IsLoaded("EOM Date Parameters") = False Then Cancel = True
'Set public variable to false to indicate that the
'Open event is completed
bInReportOpenEvent = False
End Sub
I think what I'm looking for is
DoCmd.OpenReport(qryROSTERREMINDERACTIVITY, , , , ,)
Where do I put it?
Chip
I did a little searching. My first question is does anyone know if I
can open a subreport in Landscape mode? I have a main report which is
in Portrait view and I want one of the SubReports to be in landscape
(its a table with tallys and lots of numbers).
If thats not possible, I will run the report separately. But, before
I do that, I wanted to ammend the OnOpen code for the first report, to
open the "subreport" as a separate window.... Here is the code for the
OnOpen event for the first report. How would I ammend it to then also
open the second "landscaped" report. Both report take the same
parameters, so they will all get their input parameters from the EOM
Date Parameter form.
Private Sub Report_Open(Cancel As Integer)
'Set publice variable to true to indicate that the report
' is in the Open event
bInReportOpenEvent = True
'Open sales by category dialog
DoCmd.OpenForm "EOM Date Parameters", , , , , acDialog
'Cancel Report if User Clicked the Cancel button
If IsLoaded("EOM Date Parameters") = False Then Cancel = True
'Set public variable to false to indicate that the
'Open event is completed
bInReportOpenEvent = False
End Sub
I think what I'm looking for is
DoCmd.OpenReport(qryROSTERREMINDERACTIVITY, , , , ,)
Where do I put it?
Chip