How to interupt printing a large report...

[David Mulholland]

I've ben steadily working a personnel tracker database for the nice hurricane
we had down here in Louisiana. It's been pretty well received by all the
units I support, due to a good number of tricks I've learned here. Thanks for
that

Here's what I need help with. I'm adding a report that will be run for each
soldier/airman that came to help out during our crisis. It's 1 page per
person. I have no idea who will eventually print these out...a single unit
(that could have less than 100 people) or up to a task force (which could be
a couple thousand). What I want to do is have some code behind the printing
to say 'after every 100(?) pages...pause and ask me if i want to continue'.
This will give whoever does the printing a chance to keep up with the output
while they do their administrative requirements.

Any help would be appreciated.

 

[Allen Browne]

Access is not going to do this automatically (other than pressing Ctrl+Break
to stop formatting the report.)

Therefore you might need to break the report down into batches, and print a
batch at a time (or the user could go on scheduling batchs if they wish.)

This will need some understanding of VBA and SQL to achieve. Basically, you
create a table where you record the primary key value of the records that
have been printed already, and for the next batch you select the TOP 100
that have not been printed. You can continue creating batches until all
records have been printed.

If logging to a batch table is new, here's a sample of how such a table
would work:
Has the record been printed?
at:
http://allenbrowne.com/ser-72.html

The example does not illustrate repeatedly selecting the TOP 100 until
everything is printed -- merely how to set up and log which records have
been printed.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...

 

[David Mulholland]

Thanks for the response, Allen. You've pretty much confirmed my suspicions.
I'll take a look at your example and see if I can make it work for my problem.