report appears to spool but doesn't print

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I run some code on start-up of our database to find some records that have
expired. We then create a report for these entries to send to our clients.
The report opens up fine in print preview but when we go to print a hard
copy It appears to spool (flashes now printing or something) but then
nothing prints or shows in the queue for the printer. We are using Access
2000 on Windows 2000 but the same thing happens on XP Pro machines, and
doesn't seem to work for any printer local or network.

Any ideas how to fix or where to look much appreciated.

Thanks
Chris
 
Chris:

There may be many steps to trouble shooting this problem; here's what I'd
check:

1.) First pause the printer on the local machine that the report is running
on.

2.) Then try sending the report to print. Does the Now Printing box ever go
away (i.e. the report is fully spooled?) If so check the printer que and
see if the report has actually output anything to the spooler. If so,
then it may be a printer problem.

3.) If the now printing dialog never goes away, then a.) look at any code
you have in the report, especially in the "On format" event of any section
and possibly add a wrapper around that code like this:

If FormatCount =1 then
'Your code here
End If

Otherwise your report could end up in a look where its formating, retreating
to re-format (as other data is added to the page) and its sort of stuck in a
long loop.

b.) If you are doing some type of update to records (e.g. flaging them as
selected) from code run within the report or some other method that is
called when the report is previewed, then you may be calling the update
prematurely, i.e. when the report is previewed the records are then updated
and when it is sent to print (which causes another pull from the db,) no
records are selected because they've all been updated already and so it
appears to output, but since there are no records, nothing is done.

HTH
 
Back
Top