Access Database Systems

In Microsoft Access 2007 one of the new features is to save data as PDF format files. You can also do
this by using Microsoft Access macros.

Load up the macro designer and click on the actions column. Scroll through the list of actions until you find one called ‘OutputTo’. Select this action.

At the bottom of the screen you will see the Microsoft Access macro action arguments.

-The object type will be the object you are using which could be a table, query, form etc.

-The Object name will be the name of the object – for example you may have a table called customers.

-Output format will be the type of format you wish to output the object to. This could be html, excel etc. Select PDF format here.

Output file will be the path of where you want the output to be saved.

The only other setting here which you could use is ‘Output quality’. Set this to be ‘Screen’.

Microsoft Access macro

Now save and run the Microsoft Access macro.

In Windows locate the area where your PDF was saved and open it up.

Click here to get more help with the Microsoft Access macro

Tags: MS Access, MS Access macro

This entry was posted on Tuesday, January 26th, 2010 at 11:22 am and is filed under The MS Access Macro. You can follow any responses to this entry through the RSS 2.0 feed. Responses are currently closed, but you can trackback from your own site.