Solved

Access SubReport Visible in Print Preview but will not print.

Posted on 2002-04-12
7
937 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
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
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…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

757 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

22 Experts available now in Live!

Get 1:1 Help Now