Access Report Printing losing headers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access 2000 application that is split front end (workstation) /
back end (network). The application has been running 3 years with no
problems/no changes in the area of printing. We moved from a Novell Network
to a Windows Server 2003 network recently. All normal print previewing,
then printing seems to be fine. Within the printing, there is a section
where the user can request to print and collate a report. It actually
involves previewing all of the reports and then going through a loop to
..SelectReport and .Printout 1 page of each of the 5 reports. Since we've
moved to the Windows Server, we are having problems with the headings being
lost while printing....on some of the reports. The problem is only present
in the beginning pages of the print process, after about 300 pages, it prints
all reports and headings fine. I added a "Sleep" for 1 second after each
Printout. That solved seemed to solve it that day, but now the problem is
back. I suspect its related to the network traffic or possibly printer
traffic. Any suggestions on how to completely solve this problem? Thanks
 
Hello,

Microsoft Access saves printer driver information with each form or report
that it generates. Tthe cause may be printer related even if Word, Excel
can print the file successfully. You may refer to the following article:

209782 ACC2000: Access Saves Printer Information with Each Form/Report
http://support.microsoft.com/?id=209782

I suggest that you perform the following steps to narrow down the issue:

Step 1: Print the report in the sample database northwind locally to see if
you can reproduce the issue.

Step 2: Make sure the aplication and the database on the same machine.
Print the report locally to see if you can reproduce the issue.

Step 3: Create a new test report. Print the the report using the
"Microsoft Office Document image Writer" printer.

Check if it is printed successfully. If so, the isseu is printer related. I
hope the information is helpful.

Sophie Guo
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security

=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
 
Thanks for your message. After several times back and forth with the client,
we have found that it could be the cause of Access rather than the printer
drivers. If you print to "Microsoft Office Document Image Writer" printer,
it is coming out with the headers cut off, similar to the print version we
saw. Two items that may be helpful: 1) If you print the whole report by
itself, this problem does not occur, it only happens when we are "collating"
via code (Report A Page 1, Report B Page 1, Report A Page 2, etc). 2)
Running on XP produces the header getting cut off; Running on Win2000 did
this, but only on the first page. (Please recall, that server was recently
changed from Novell to Win Server2003) .

My question is, since I'm not there, and I don't have the same type of
printer that the user does, and since they don't always print to the same
printer, how do we solve the problem? We can't possibly ask them to go into
the reports in design mode, make an unknown change and set the printer every
time? Do I have to do this through code some how? And Why wasn't this a
problem in the old environment?

thanks.
 
Hello,

To help me troubleshoot the issue, please check if you can reproduce the
issue on the sample northwind database. If so, please post here the
detailed steps to reproduce the issue and I will chceck it on my side.

Or you can create a new blank Access database, then try to reproduce the
issue on the new database. If you can reproduce it, package the file with
winzip and send me the new database. I will check it on my side. My email
address is (e-mail address removed). Please write the subject as 30545131:
Access Report Printing losing headers. I look forward to hearing from you.

Sophie Guo
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security

=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
 
Back
Top