Solved

Creating Acrobat reports via MS Access and VBA

Posted on 2007-04-01
6
246 Views
Last Modified: 2008-02-01
I have an Access database, that allows me to be able to run reports, export them to XLS, CSV, Snapshot etc and then email the required files as attachments - this works perfectly for most clients.  However, one of my clients has Apple Macs and require the graphical (Snapshot) file.  Unfortunately, I do not believe that Snapshot is supported under Macs (but if I am wrong please let me know - it would make my life far easier).  The solution I developed ment creating a Word document, running a mail merge and sending them this file - but this is cumberson.

Acrobat seems like the right solution, but only a couple of my clients have it and it needs to be integrated into Access - so I can create the PDF and then add it as an attachment.  Since not all of my clients have the Acorbat writer, I would need to use late binding and a check to see if the PC has the Acrobat writer installed before running the report.  I believe there is a SDK - but have not experience in writing the VBA code for such a process.

Any help would be really appreciated.
0
Comment
Question by:Andy Brown
6 Comments
 
LVL 1

Accepted Solution

by:
martinveen earned 200 total points
ID: 18831673
Look at:  www.lebans.com

Stephen Lebans has a function that exports report to Snapshot and then to PDF. Output exact duplicate of a Report to PDF.

Your code would look like this:
   blRet = ConvertReportToPDF(<RptName>, vbNullString, <RptName> & ".pdf", False, True, 0, "", "", 0, 0)
0
 
LVL 38

Assisted Solution

by:puppydogbuddy
puppydogbuddy earned 200 total points
ID: 18831871
Hi Andrew,
I agree with Martinveen, Lebans is the way to go.  One correction: you do not need to export to Snapshot first.  Like Martinveen, I used to think you did, but Jeff Willey convinced me otherwise.  See the link below for details on Jeff's implementation of the Lebans method.

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21944675.html
0
 
LVL 34

Assisted Solution

by:jefftwilley
jefftwilley earned 100 total points
ID: 18832330
see this for information about checking if Adobe is installed

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21290913.html
J
0
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 

Author Comment

by:Andy Brown
ID: 18832501
Thanks everyone - that's perfect - I'll have a play.
0
 
LVL 38

Expert Comment

by:puppydogbuddy
ID: 18832541
Andrew,
Thanks for the points and grade.  Just for the record, I found this link to Tony Toew's web site, which also supports the Lebans method and  has additional info.
                   http://www.granite.ab.ca/access/pdffiles.htm

<o/t>
Hello Jeff,
Good to see you back in action! :-)
0
 
LVL 34

Expert Comment

by:jefftwilley
ID: 18832545
Hey PDB,
Thanks for caring :o)
My vacation is over I guess! lol
See you round@EE
J
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How Can I Grab This Information off a PDF Form 23 48
Delete Records on a Form in Microsoft Access 5 39
Should I keep recordsets open? 3 24
Switch 5 16
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
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.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

770 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