If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access Report Printing losing headers
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 |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
Access Report Printing losing headers
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. "Sophie Guo [MSFT]" wrote: 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. |
#4
|
|||
|
|||
Access Report Printing losing headers
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 . 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
No current record 3021 | hughess7 | General Discussion | 30 | August 19th, 2005 04:39 PM |
2002 vs 2003 | Patrick Stubbin | General Discussion | 2 | May 17th, 2005 07:27 AM |
Printing Preview Doesnt Match the Printed Report | ianc via AccessMonster.com | Setting Up & Running Reports | 1 | February 3rd, 2005 05:23 PM |
Access XP Compared to Access 2003 | Mardene Leahu | New Users | 1 | October 1st, 2004 05:11 AM |
adobe printing from access report | SYSWORKING | General Discussion | 1 | September 2nd, 2004 03:25 PM |