Access Report to PDF

Hello Experts,

I have an Access application with all menus and toolbars disabled.  However, I need to give the user to convert certain Reports to PDF.

Is there a quick way of doing this, by enabling/creating certain toolbars, or a few lines of code?

Thank you.
APD TorontoAsked:
Who is Participating?
 
Paolo SantiangeliConnect With a Mentor Consulente InformaticoCommented:
access version?
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
If you are using A2010 ... it's easy:

    DoCmd.OutputTo acOutputReport, "rptPDFTest", acFormatPDF, "C:\rptPDFtTest.pdf", False


mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
If you are using A2007 or prior, this works great ... I have it in several apps:

http://www.lebans.com/reporttopdf.htm

mx
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
APD TorontoAuthor Commented:
Its Access 2007
0
 
APD TorontoAuthor Commented:
The default A2007 has a pdf button
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
With all due respect, the Accepted answer is not really an answer ... it's a Question ...

mx
0
 
APD TorontoAuthor Commented:
Well, i found the answer on my own, but wanted to reward both participants, not myself
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.