Solved

Create a PDF file by VBA in Access 2000

Posted on 2008-09-29
3
497 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: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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

Inserting page numbers in Portable Document Files not only enhances manageability but also makes them look professional. With numbered pages, the file appears more organized and it becomes easier to search for a particular page. The size and the vol…
*Adobe Acrobat 9 was used for this article.  Particular steps may vary depending on software versions. Adobe Acrobat has many, many variables that my be utilized to customize your forms for clarity and ease of use. The Form Editing Tool will be y…
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…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

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