Solved

Create a PDF file by VBA in Access 2000

Posted on 2008-09-29
3
489 Views
Last Modified: 2013-11-28
Hi to all,
I would like to create PDF file in Access 2000 by VBA code.
Is there a way to save or export forms or reports in PDF format? I prefer not to use third party software. I need to distribute this database to different users and do not like them to be confused by another software.

Thanks
VFSIT
0
Comment
Question by:VFSIT
[X]
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
  • 2
3 Comments
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 22595229
No. Your enduser must have some form of PDF creation software on their machine, and in order for your application to work correctly you must know which they are using ... in other words, you'd be much, much better off either (a) specifying what software your enduser must have (and then checking for it) or (b) deciding which to use and then shipping that with your app.

The standard for this is the Lebans method: www.lebans.com/reporttopdf.htm. This is freely distributable.

0
 

Author Comment

by:VFSIT
ID: 22596719
Thanks LSMConsulting. It is not what I realy like to do but it seems I have no other option.
I accepted your solution but again when I clicked on submit, the point allocation page did not come up on my screen. I would like to assign 500 points to your account but dont know how?!!

Regards,
VFSIT
0
 
LVL 84
ID: 22598459
You already did. You graded this question a B, and gave me 500 points.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

740 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