Access Database Systems

WelcomeBlog

Are your business objectives being met?

Do you need specialised Access database consulting or an Access database solution? Our software is dedicated to providing assistance toward increasing efficiency and productivity of the small or medium sized business.

If you do not have the resources or time to develop software for your business, you may find something of interest here.

«
»

Create a PDF file with a Microsoft Access macro

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: ,

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.

Comments are closed.