?
Solved

Access SubReport Visible in Print Preview but will not print.

Posted on 2002-04-12
7
Medium Priority
?
953 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
What Is Blockchain Technology?

Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.

 
LVL 5

Expert Comment

by:chewhoung
ID: 6938241
me too chewhoung2@yahoo.com
0
 
LVL 58
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

10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Suggested Courses

800 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