User defined print range

  • Thread starter Thread starter cebubum via AccessMonster.com
  • Start date Start date
C

cebubum via AccessMonster.com

In Access 2000, WinXP, I created an Access db and installed it on a single
machine and shared it on a small office network. I set the startup so that
the switchboard is the starting form, and the users cannot access the full
menues, etc. Very basic security which is not a problem in my case.
Everything is working well, except for two items.

The first is I cannot print in excess of 66 pages of a report. Most reports
generated are from 50~80 pages. I am using a Samsung laser printer. Any ideas
or suggestions as to where to start looking for a solution?

Secondly, even though I have filters for the reports, I sometimes only want
to print a specific page or range of pages. Is there a way to allow the user
to specify the range of pages to be printed when they do not have access to
the normal print controls?

I have searched the posts and have not come across either of these problems.
Any help or advice would be gratefully appreciated.

Cebubum
 
Cebubum:

Relative to the printer not outputting more than 66 pages, a.) Have you
tried updating the printer driver for the printer? b.)are there a lot of
images on the report, or use of the line control in the report? If so, try
reducing the size or resolution of the images (i.e. lowing dpi) or changing
the images from jpegs or gifs to bitmap images (uses less memory); and try
changing lines to rectangles and sizing them to be lines. (again less
memory).

On the page selection, you might want to take a look at our "On the Fly
Printing" classes for Access. With it you can call a function from the
form from which the reports are called, and spaun a print dialog which will
allow the user to select a page range.

Hope this helps
 
SA, Thank you for the suggestions. There are no graphics in the reports.
Strictly text, all 8 pt
Arial. Not even color. I will try to update the driver tonight. It is a new
printer which doesn't mean much these days.

I will take a close look at the "on the fly" printing.

Best Regards
Cebubum
Cebubum:

Relative to the printer not outputting more than 66 pages, a.) Have you
tried updating the printer driver for the printer? b.)are there a lot of
images on the report, or use of the line control in the report? If so, try
reducing the size or resolution of the images (i.e. lowing dpi) or changing
the images from jpegs or gifs to bitmap images (uses less memory); and try
changing lines to rectangles and sizing them to be lines. (again less
memory).

On the page selection, you might want to take a look at our "On the Fly
Printing" classes for Access. With it you can call a function from the
form from which the reports are called, and spaun a print dialog which will
allow the user to select a page range.

Hope this helps
In Access 2000, WinXP, I created an Access db and installed it on a single
machine and shared it on a small office network. I set the startup so
Click to expand...
[quoted text clipped - 22 lines]
Cebubum
Click to expand...
Click to expand...
 
Back
Top