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

Create a PDF file by VBA in Access 2000

Posted on 2008-09-29
3
478 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
  • 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

Suggested Solutions

Title # Comments Views Activity
Single Step Macro 4 41
corrupt Databases 9 63
Access/Visual Basic Question 3 24
modifying sql to include addl criteria 11 10
This article focuses on how to remove password security from multiple PDF files by Adobe Acrobat program. Sometimes it is essential to access the stored data items and to print, edit as well as copy content from Portable Document Format files in abs…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
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 Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

809 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