[AccessD] Automating pdf printer

Joe O'Connell joeo at appoli.com
Fri Nov 19 00:40:50 CST 2010


Carolyn,

There may also be a problem if your users have 64 bit computers.
Lebans' was designed to work with 32bit operating systems.

Joe O'Connell  

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Carolyn
Johnson
Sent: Thursday, November 18, 2010 10:33 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Automating pdf printer

I need a method to create pdfs that does not require the installation of
any other software or printer -- the database is used by a number of
organizations with a variety of computers that changes year to year.
And the computers have varying operating systems (XP to Windows 7) and
versions of Access (2000 to 2010).  

Lebans code worked great for me until 2010.  And the quality of the pdfs
was never an issue.

It's interesting that the code still produces a pdf, but a portrait
oriented document gets cut off and looks like it's printed in landscape.
I would have guessed it wouldn't create a pdf at all.


Carolyn Johnson

  ----- Original Message ----- 
  From: Darryl Collins 
  To: Access Developers discussion and problem solving 
  Sent: Thursday, November 18, 2010 6:41 PM
  Subject: Re: [AccessD] Automating pdf printer



 
________________________________________________________________________
_______________

  Note: This e-mail is subject to the disclaimer contained at the bottom
of this message.
 
________________________________________________________________________
_______________



  The other 'downside' with using Access > snapshot > PDF is the final
PDF output is a 2nd generation image.  This can result in degraded image
quality in my experience - if a detailed and sharp result is required
this method is inadequate for the task I have found.  A single output to
PDF is preferable.

  Regards
  Darryl.

   

  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Carolyn
Johnson
  Sent: Friday, 19 November 2010 11:29 AM
  To: Access Developers discussion and problem solving
  Subject: Re: [AccessD] Automating pdf printer

  Stephen Lebans code to create pdfs uses the snapshot format of a
report to create the pdf file.

  Snapshot file format is no longer available in Access 2010 == explains
why it doesn't work well in that version.


  Carolyn Johnson



  >>> jwcolby at colbyconsulting.com 17-11-2010 21:17 >>>
  A client wants to print stuff to a pdf and send the email.  I would
create a report and send it to 
  the printer, then pick up the resulting file and send an email.

  I know how to do everything except the pdf part in the middle.

  Is anyone doing this?
  -- 
  John W. Colby
  www.ColbyConsulting.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
 
________________________________________________________________________
_______________

  The information transmitted in this message and its attachments (if
any) is intended 
  only for the person or entity to which it is addressed.
  The message may contain confidential and/or privileged material. Any
review, 
  retransmission, dissemination or other use of, or taking of any action
in reliance 
  upon this information, by persons or entities other than the intended
recipient is 
  prohibited.

  If you have received this in error, please contact the sender and
delete this e-mail 
  and associated material from any computer.

  The intended recipient of this e-mail may only use, reproduce,
disclose or distribute 
  the information contained in this e-mail and any attached files, with
the permission 
  of the sender.

  This message has been scanned for viruses.
 
________________________________________________________________________
_______________

  -- 
  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