Printing issue with Reports - Access 2000

  • Thread starter Mel Morris (Global Egg Corporation)
  • Start date
M

Mel Morris (Global Egg Corporation)

I have a recurring issue. Although reports created a while ago seem fine. Any
reports created recently print all the pages on one page, ie. each page is
superimposed on the one page making it illegible - even if the report is
supposed to be 100 pages long, it will come out on one page with all 100
pages superimposed on the page in a mass of black ink.
It does not happen when I print forms, it does not happen of course if I set
the print parameter for the report one page at a time, but obviously for a
100 page report I do not want to send 100 print jobs to the printer, the
printer is Canon Ir 3320 and works perfectly well in every other program. It
is only in Access and only on Reports. I should mention that the reports
preview perfectly!
Any help would be greatly appreciated, as this is driving me nuts
Mel Morris
 
V

Van T. Dinh

* Do you have any VBA code in the Report's module, especially the
Detail_format Event?

* Try creating a really simple Report that print over 2 pages and see if you
can duplicate the problem.

--
HTH
Van T. Dinh
MVP (Access)



"Mel Morris (Global Egg Corporation)"
 
M

Mel Morris (Global Egg Corporation)

Thanks for your Response Van, I appreciate it.

I am not a programmer, so I usually use Wizards to create the reports, I do
adjust sometimes after the fact.

I did as you suggested, and made a similar report which was just a subset of
the other report really, which turned out to be 3 pages, and seems to have
printed perfectly. I'm not sure what this tells me though, because once
before, when I had this issue I tried printing saying pages 1 - 7 etc to see
if I could just print a few pages at a time (better than just 1 at a time)
and they still printed on top of each others.

Any more suggestions (I"m planning on getting my IT bod to upgrade us to
2002or3 because I've heard the Access 2000 is a bit 'buggy'.

Thanks again
Mel Morris
 
M

Mel Morris (Global Egg Corporation)

As a follow up - I changed some parameters to produce a 7 page report and it
failed ie all pages were superimposed, then I reset the parameter to the
original subset which yielded the 3 page report and this time it failed as
well, so the report that printed perfectly the first time, now superimposes
every page on one page, So now I am really confused
Mel Morris
 
M

Mel Morris (Global Egg Corporation)

Thanks again Van.

I actually have service pack 3 - which was supposed to fix another issue i
have with landscape/legal report formatting - losing the formatting and
reverting to defaults, but it doesn't.

I will see if there are any more updates, and I will check for later printer
drivers. That is a good idea.
THanks again
Mel Morris
 
V

Van T. Dinh

1. Check that your Access installation is up-to-date. The original Access
release was bugsy but since Service Release 1a (SP-1a), it works quite OK.
There are a number of Service Packs since then and I have no problems with
using Access2000. Apply all the SRs / SPs for Access2000 / Office2000 as
suggested by the Microsoft Update.

2. Also update your Windows OS with all Service Releases / Service Packs.

3. Check the printer manufacturer's Web site and update the printer driver
to the latest one available.

--
HTH
Van T. Dinh
MVP (Access)



"Mel Morris (Global Egg Corporation)"
 
Top