Report only prints 127 pages

  • Thread starter Thread starter David Gartrell
  • Start date Start date
D

David Gartrell

Hi There,

I wonder if anyone can help me out with a BIG problem I have

I have a database running on Access 2000 and within it I have a report set
up that produces product picking notes. At the moment it needs to print off
285 of these picking notes and yet whenever I send the report to the printer
it will only print off the first 127 pages. However when i view the print
preview of the report on the screen I can see all 285 pages so I know my
database is working correctly - its very frustrating!! I've even tried
printing it off from 3 different PCs and to 2 different printers but the
results are the same. I'm wondering whether i've hit some sort of
limitation within Access or whether I ay have found some sort of bug.

I've searched Microsoft's Knowledge Base but without success. Can anyone
help me please - if you've had any similar experience and can help me out or
you know what the problem is then I'd be very grateful.

Many thanks

David.
 
First thing to check would be that you have the latest service pack. Choose
About on the Help menu. If you do not see:
Access 2000 SP3
then go to support.microsoft.com, and get Service Pack 3 for Office 2000.
(While you are there, make sure you get SP 8 for JET 4 as well. It's in the
Downloads section.)

If that does not solve the problem, is there any code in any of the events
of the report?
What version of Windows? Is the TEMP environment variable pointing to a
valid folder?
 
IN addition to Allen's comments, and until you find the true source of
this issue, you can try to use the PrintOut method to print your report
programmatically. Remember to SELECT the desired report prior to
issueing the call to the PrintOUt method.

The PrintOut method carries out the PrintOut action in Visual Basic. For
more information on how the action and its arguments work, see the
action topic.

Syntax

DoCmd.PrintOut [printrange][, pagefrom, pageto][, printquality][,
copies][, collatecopies]

The PrintOut method has the following arguments.

Argument Description
printrange One of the following intrinsic constants:
acPrintAll (default)
acSelection
acPages
If you leave this argument blank, the default constant (acPrintAll) is
assumed.
pagefrom A numeric expression that's a valid page number in the active
form or datasheet. This argument is required if you specify acPages for
the printrange argument.
pageto A numeric expression that's a valid page number in the active
form or datasheet. This argument is required if you specify acPages for
the printrange argument.
printquality One of the following intrinsic constants:
acDraft
acHigh (default)
acLow
acMedium
If you leave this argument blank, the default constant (acHigh) is
assumed.
copies A numeric expression. If you leave this argument blank, the
default (1) is assumed.
collatecopies Use True (-1) to collate copies and False (0) to print
without collating. If you leave this argument blank, the default (True)
is assumed.
Remarks

You can leave an optional argument blank in the middle of the syntax,
but you must include the argument's comma. If you leave one or more
trailing arguments blank, don't use a comma following the last argument
you specify.


EXAMPLE:
The following example prints two collated copies of the first four pages
of the active form or datasheet:

DoCmd.PrintOut acPages, 1, 4, , 2
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Back
Top