[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 299
  • Last Modified:

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.
0
APD_Toronto
Asked:
APD_Toronto
  • 3
  • 3
2 Solutions
 
Paolo SantiangeliConsulente InformaticoCommented:
access version?
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
If you are using A2010 ... it's easy:

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


mx
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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 quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

 
APD_TorontoAuthor Commented:
Its Access 2007
0
 
APD_TorontoAuthor Commented:
The default A2007 has a pdf button
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now