Creating Acrobat reports via MS Access and VBA

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.
Andy BrownDeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
puppydogbuddyCommented:
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
jefftwilleyCommented:
see this for information about checking if Adobe is installed

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21290913.html
J
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Andy BrownDeveloperAuthor Commented:
Thanks everyone - that's perfect - I'll have a play.
0
puppydogbuddyCommented:
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
jefftwilleyCommented:
Hey PDB,
Thanks for caring :o)
My vacation is over I guess! lol
See you round@EE
J
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.