Solved

Access SubReport Visible in Print Preview but will not print.

Posted on 2002-04-12
7
938 Views
Last Modified: 2006-11-17
Hi, I have what appears to be a tough subreport problem. I was sent a database from a frustrated friend that was converted from Access 97 to Access 2000. These reports worked fine in Access 97.
Everything works fine in Access 2000 with the exception of the subreports in two reports. These subreports are in the page header.  They display correctly in print preview but will not print with the main body of the report.  I have looked at the obvious things, but this quite frankly has me stumped.
I do not think this is something that can be readily solved without sending the DB (around 550K zipped).  
If anyone is interested in looking at it and can come up with a solution, it would be very much appreciated. I've run out of ideas.

Thanks, Dan    Email:  pdldavis@yahoo.com
0
Comment
Question by:pdldavis
7 Comments
 
LVL 54

Expert Comment

by:nico5038
ID: 6937269
Drop it Dan, emailaddress is in my profile, just click my name ;-)

Nic;o)
0
 
LVL 12

Expert Comment

by:Paurths
ID: 6937279
hi Dan,

seems interesting to take a look at it, ricky.thijs@pandora.be

cheers
Ricky
0
 

Expert Comment

by:treymoran
ID: 6937285
I'll take a look.  trey@moranonline.com
0
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 5

Expert Comment

by:chewhoung
ID: 6938241
me too chewhoung2@yahoo.com
0
 
LVL 57
ID: 6939983
This can often be caused by a printer driver problem.  Here are a couple of things you can try:

1. Change the printers spool format from RAM to EMF (or the other way around).

2. Set the reports "Fast Laser Printing" property to no.

3. Set the reports "Layout for Print" setting to Yes.

4. Update the printer driver or try testing with a simple driver, such as HP LJ III

5. If the printer driver has a setting something like "Print True Type fonts as graphics", make sure it's on.

  Outside of that, it could be a bug.  I just worked on aother problem with A2000 that involved Keep Together.  With the data presented and options that were chosen, a blank page resulted every time.

HTH,
Jim.
0
 
LVL 54

Expert Comment

by:nico5038
ID: 7103244
for pdldavis

No comment has been added for the last two months.
So it's time to clean up this TA.
I will leave a recommendation in Community Support that this question is:
 - PAQ'd and pts refunded
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)
0
 
LVL 5

Accepted Solution

by:
Netminder earned 0 total points
ID: 7128835
Per recommendation, points refunded and question closed.

Netminder
CS Moderator
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now