[AccessD] PDFCreator with Access

Jim Lawrence accessd at shaw.ca
Sat Jul 24 16:09:46 CDT 2010


Hi Stuart:

Thanks for the tip...I just ran into a mental block. I did finally solve the
problem by adding the following line after setting the PDFCreator object but
before running the print report command:

Application.Printer.ColorMode = acPRCMColor

...and that seems to solve the problem.

Thanks again
Jim

 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Saturday, July 24, 2010 12:20 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] PDFCreator with Access

File, Page Setup, Page - Use a specific printer.  

In the selection box, select PDFCreator, click on Properties and select
Black and White.

-- 
Stuart


On 24 Jul 2010 at 11:58, Jim Lawrence wrote:

> Hi Stuart:
> 
> I did not know that Access reports could be set to black & white?
> Where is this setting made?
> 
> TIA
> Jim
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart
> McLachlan Sent: Saturday, July 24, 2010 11:25 AM To: Access Developers
> discussion and problem solving Subject: Re: [AccessD] PDFCreator with
> Access
> 
> My first guess    would be that the sub-report was formatted to print
> in B&W and that is overriding the settings for the main report  (since
> it is the first part built by Access.)
> 
> 
> -- 
> Stuart
> 
> 
> On 24 Jul 2010 at 11:08, Jim Lawrence wrote:
> 
> > Hi All:
> > 
> > I have been using PDFCreator extensively with MS Access and it has
> > been a solid and relieable app for creating PDF files. 
> > 
> > One particular client has a coloured JPG graphic header file which
> > is attached to all their Access reports. All their reports print
> > just fine except for one. There is no error but when this report is
> > printed within the program the colour JPG header is conveted to
> > monochrome.(?)
> > 
> > 
> > If the report is printed in direct manual mode the report retains
> > its colour... the problem only shows itself when printed within the
> > program. It does not matter what OS is running XP/Vista/Windows7, or
> > memory from 1GB to 8GB of RAM, or how many pages from 1 to 6 but
> > there is one difference though.
> > 
> > The report has a subreport. If the subreport is removed, back comes
> > the colour. I have left a message on the PDFCreator forum but so far
> > no responses but as the problem is a MS Access one if the question
> > can be answered it would be here.
> > 
> > TIA
> > Jim    
> > 
> > -- 
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> > 
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list