separate report into 100-page packs

[MattE]

I've got a report that prints onto 4x6 cards, just one per page with
no perforation. They come in 100-card packs.

I'm trying to figure a way to have the report generation pause after
100 cards and allow the user to continue or cancel. If a report's
record source is a query, is there a way in code to change the limit
in that query and then OpenReport again to print the next batch? Hope
this make sense! Any better ideas?

 

[Boyd Trimmell aka HiTechCoach via AccessMonster.co]

I think you probably could to use a temp table and VBA code to print 100
records/cards at a time. There may be another solution, but this should work.

I've got a report that prints onto 4x6 cards, just one per page with
no perforation. They come in 100-card packs.

I'm trying to figure a way to have the report generation pause after
100 cards and allow the user to continue or cancel. If a report's
record source is a query, is there a way in code to change the limit
in that query and then OpenReport again to print the next batch? Hope
this make sense! Any better ideas?

--
Boyd Trimmell
aka HiTechCoach
http://www.hitechcoach.com
http://www.officeprogramming.com

Message posted via AccessMonster.com