Solved

Access SubReport Visible in Print Preview but will not print.

Posted on 2002-04-12
7
945 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
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.

 
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Familiarize people with the process of utilizing SQL Server views 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 Access…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

679 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