Solved

Creating Acrobat reports via MS Access and VBA

Posted on 2007-04-01
6
249 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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
trim dropdown value before executing query 8 30
Database keeps telling me Recordset Locked 10 25
Access Schema 6 27
Email Populated Report as PDF 2 15
In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

821 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