May 12 2005, 05:50 PM
I have a two page report that contains one subform and 2 subreports. I am attempting to duplex print it on either an HP 8150 or a Xerox Workcentre M55. Everytime I print it, it begins spooling and printing, but then I get an msaccess error and the program shuts down.
I have tried different drivers for both printers. I have tried different computers. I have tried different operating systems. All have the same problem.
May 13 2005, 10:04 AM
have a two page report that contains one subform
Try making this into a subreport.
What is the exact error? Have you compiled your database and preformed a repair and compact?
May 13 2005, 10:50 AM
The exact error is "msaccess.exe has generated errors and will be closed by windows." I am currently running Windows 2000. I am using an Access Project that has been compiled and is in .ade format. I have compacted and repaired the original database file, but that did not help. I will attempt to turn the subform into a subreport, but would like to know if you have any other thoughts.
May 13 2005, 10:54 AM
Does it crash when you print regularly (no duplex)?
May 13 2005, 11:07 AM
On this report, yes, it crashes with or without duplex. Other than this one report, I have had no problems like this.
May 13 2005, 11:26 AM
Try these commands from the immediate window:
saveastext acReport,"Report Name", "C:\rpt.txt"
Rename your existing report then run this command
loadfromtext acReport, "Report Name","C:\rpt.txt".
You may need to execute this for the main report and all sub reports.
May 13 2005, 01:09 PM
Okay, I did what you recommended and tried to print. It worked.
First, thank you.
I am assuming, perhaps just that report or one of its subs must have been just a little corrupt. Then I'm guessing you had me convert the report and its subs to a text file and reimport them back into the database, with the hopes the corruption would be lost when it was converted/reimported. I would love an explanation though.
By the way, THANK YOU again.
May 13 2005, 01:13 PM
You are correct with your assumption. As for an explanation of how and why, I don’t have one - these things just happen.
Glad I could help.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here