Wrox Programmer Forums
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 21st, 2004, 11:44 AM
Registered User
 
Join Date: Dec 2004
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default Convert access reports to pdf

Hello, do you have any idea to convert access reports to pdf?
I know how to convert xls files but it appears that I cannot use the same code for access.

 
Old December 21st, 2004, 05:35 PM
Registered User
 
Join Date: Nov 2004
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I don't think that you can do this directly - unless you own a full version of Acrobat and print to a pdf. You can print as an .snp file, which is much like a pdf. Also, you can export as a Word .rtf file; the text looks good, but you loose lines and graphics.

 
Old December 23rd, 2004, 10:13 AM
Registered User
 
Join Date: Dec 2004
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I thought it could be possible as I managed to convert xls files to pdf. It's rather strange that the method PrintOut has different parameters in vba access and vba excel. How can it be??

 
Old December 29th, 2004, 05:51 PM
Registered User
 
Join Date: Nov 2004
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

If you have Acrobat on the machine, you could print to Acrobat as the printer, but that would demand more of your user, as I think Acrobat makes you set up the format etc.

I don't have much experience with Excel VBA, so cannot comment on the difference.






Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert Crystal reports from access to sql server sunbagga Pro VB Databases 9 July 16th, 2007 05:57 AM
Convert SNP (MS ACCESS snap shot) to PDF with C# roypython C# 0 March 12th, 2007 12:21 AM
Need to Convert ASP to PDF metrov Classic ASP Databases 2 March 9th, 2007 08:10 AM
Convert Crystal reports from Access to Oracle atakhan Pro VB Databases 2 July 4th, 2004 01:33 AM
Sending Access Reports to PDF Format jhartwick Access VBA 1 May 2nd, 2004 08:00 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.