Combine Reports

[Mattias]

Hi,

Is is possible to either;

1, Have a report where different pages have different orientation?
2, Combine a bunch of reports into one file (e.g. appending to a snapshot)

Oh, forgot, I'm using Access 2003 and VBA

Thanks,
Mattias

[OBP]

Mattias, I don't know of any way to do either option. You can put snapshots in one folder, if you wanted to send someone the data.
It might be possible to change orientation in a report using VBA, but I can't see how, if you use the "On Format" event I think that it is already too late to change the orientation. If you use the "On Load" event it would fix it for all of the pages.

REVISION.

I have had a look at the events and there is an OnPage event where you could try using the
"Reports("Purchase Order").Orientation = 1"
based on a current page number using the "Page Property" as in Me.Caption = "Now Viewing Page " & Me.Page & " Of " & Me.Pages & " Page(s)"

Good Luck, let us know if it works