vb123.com

Garry Robinson's Popular MS Access, Office and VB Resource Site

 

Home  Contact Us
Order our Software

RSS & Newsletter  
Join our XML/RSS Newsfeed or sign up for our informative newsletter on Office Automation, Access and VB topics
Read More

Get Good Help
If you need help with a database, our Professionals could be the answer
Read More

  Is Your Database Corrupt ?
If you have a corrupt database, Try our Access Recovery service

The Workbench  Find out who has your database open, start the correct version of Access, easy compacting and backups, change startup options, mde compile,  shutdown database Read and Download

The Toolshed 
Searchable help file comprising of all the information at vb123.com plus hidden downloads etc. Read More



The Toolbox

Libraries of software that we regularly import into our projects. This is a newer version of the Toolshed More..


Access >>> SQL 
Upsize to SQL Server 2005 or 2008, easily repeated conversions, highly accurate SQL query
translation and web form conversion.
Read More


DryToast 
Backup and query your BaseCamp
® projects
Read More


Datamining/Graphs

Explore your data with this versatile graphing and data mining shareware tool.  Read More

Garry's Blog
Find out a few other things that Garry has been writing about Microsoft Access. Read more

About The Editor Garry Robinson writes for a number of popular computer magazines, is now a book author and has worked on 100+ Access databases. He is based in Sydney, Australia
Contact Us ...

Search ...

or try our new site built with SharePoint Designer
 vb123.com.au
 

 

Next Tip     Save Reports and Other Printable Objects As PDF Files From Access

Following are a list of the things that you should know about if you are interested in saving Access reports and other printable objects in Portable Document Format (PDF) format.  All of this material also applies to the conversion of any printable object (Word, Excel) to PDF format.

Before you start, you will need to purchase or find software that will act as a PDF Printer Driver. The examples on this page come come from Nitro PDF Professional Version 5.4.

Click Here to join Garry's Popular Access Unlimited Newsletter

Its Handled Thru A Printer Driver

The saving of reports is handled through a special printer driver that converts printed output into PDF format.  This is managed through the Nitro PDF Printer Driver software.  Because it is a printer driver, any software that can print can output to a PDF file.  The following images can be expanded to show the full view if they have a blue line around. 


Figure 1 - Save to PDF happens through a printer driver.  

 


Figure 2 - Save to PDF using the NitroPDF printer driver

When you say OK to print, you will then be prompted for the name of the PDF file that you want to save.  The default name will be the name of the Access report. 


Figure 3 - Choose the name of your PDF file

Working With The PDF File

There are many changes that you can now make to the report using the modern Nitro PDF Professional interface. The following interface screen shots shows you most of the actions you can undertake on your PDF document.


Figure 4 - The Home ribbon

 


Figure 5 - Part of the editing Ribbon  Read on web site



Figure 6 - The full editing ribbon

 


Figure 7 - A PDF that has had both a watermark and a comment added to it

 


Figure 8 - The PDF Forms Ribbon

 


Figure 9 - The security and signature ribbon

 


Figure 10 - The Viewing Ribbon, something that would come in handy for large documents

 


Figure 11 - The Help Ribbon is a work of Art

 


Figure 12 - The Save Menu will be very familiar with Office 2007 users

Summing Up

Nitro Pro is a really fun program to use and makes management of PDF files a breeze. In my view it is the best Ribbon interface that I have used. One of the reasons for this is that Nitro have correctly identified that a Ribbon menu is most suited to the tasks of working on a PDF document.

Now you may want to read about other (some free) PDF generators and printer drivers that our readers have recommended. Links for resources on cheap PDF File Generators

Note:  Access 2007 and the Rest of Office has a free download to produce PDF files. This integrates nicely with NitroPDF if you make Nitro the default PDF reader on your computer.
 

Click on the Next Tip button for the next page in this Access Loop.

Other Pages at vb123 That you might want to read

How We Read A PayPal Notification Email Using VBA
Issue 18 Of Access Unlimited - More on the Access Snapshot 
Send SMS with Skype 3

 

Links >>>  Home | Search | Workbench | Orders | Newsletter | Access Security | Access professionals