Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Access Report to PDF

Posted on 2011-09-08
7
285 Views
Last Modified: 2012-05-12
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
Comment
Question by:APD_Toronto
  • 3
  • 3
7 Comments
 
LVL 11

Accepted Solution

by:
Paolo Santiangeli earned 250 total points
ID: 36505169
access version?
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 250 total points
ID: 36505219
If you are using A2010 ... it's easy:

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


mx
0
 
LVL 75
ID: 36505278
If you are using A2007 or prior, this works great ... I have it in several apps:

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

mx
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

Author Comment

by:APD_Toronto
ID: 36505367
Its Access 2007
0
 

Author Comment

by:APD_Toronto
ID: 36505482
The default A2007 has a pdf button
0
 
LVL 75
ID: 36505545
With all due respect, the Accepted answer is not really an answer ... it's a Question ...

mx
0
 

Author Comment

by:APD_Toronto
ID: 36506116
Well, i found the answer on my own, but wanted to reward both participants, not myself
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
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.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

839 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