Printing Multiple Reports

[M. Wilson]

Hello,

I have a booklet that had to be converted into a report. I broke the
booklet into 10 separate Access reports. I want them to print them one at a
time.

First I open all of the reports then I want to print page 1 of all 10 of the
reports then page 2 of all of the reports and so on.

Right now, I use the following set of statements...

for i = 1 to 44
reports!report1.setfocus
printout ....
next i

However I get an error message on the setfocus line. Does anyone know how
to move focus to other reports that are open? Any suggestions would be
greatly appreciated.

Thanks,
M. Wilson

 

[Chuck]

Hello,

I have a booklet that had to be converted into a report.

Is the booklet an electronic file of some sort or a hard copy?

Chuck

 

[M. Wilson]

It is a hard copy.

Is the booklet an electronic file of some sort or a hard copy?

Chuck

 

[Chuck]

Hello,

I have a booklet that had to be converted into a report. I broke the
booklet into 10 separate Access reports. I want them to print them one at a
time.

First I open all of the reports then I want to print page 1 of all 10 of the
reports then page 2 of all of the reports and so on.

Right now, I use the following set of statements...

for i = 1 to 44
reports!report1.setfocus
printout ....
next i

However I get an error message on the setfocus line. Does anyone know how
to move focus to other reports that are open? Any suggestions would be
greatly appreciated.

Thanks,
M. Wilson

Your code is looking for a report named report1. Does that report exist? If
it does then your code should print 44 copies of report1. If report1 is
actually a variable then the code that assigns the contents of report1 must be
inside the for i loop. If you only have 10 reports, why loop 44 times? I
would expect trouble if you run out of reports to print.

I don't write code so I can't tell you exactly what you need. All I can do is
look at the logic of your code and make suggestions.

If this were my job, I'd make 10 macros, one to print each report. Then I'd
put a single command button on a form to call the 10 macros. Not nice, neat
and clean, but it'll work.

Chuck

 

[Chuck]

Hello,

I have a booklet that had to be converted into a report. I broke the
booklet into 10 separate Access reports. I want them to print them one at a
time.
Snip

Thanks,
M. Wilson

Just curious. How did you convert a hard copy booklet to Access reports?

Chuck