separate report into 100-page packs

  • Thread starter Thread starter MattE
  • Start date Start date
M

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?
 
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?
Click to expand...

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

Message posted via AccessMonster.com
 
Back
Top