Solved

Access SubReport Visible in Print Preview but will not print.

Posted on 2002-04-12
7
947 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

734 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