Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 556
  • Last Modified:

Create a PDF file by VBA in Access 2000

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
VFSIT
Asked:
VFSIT
  • 2
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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
 
VFSITAuthor Commented:
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
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You already did. You graded this question a B, and gave me 500 points.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now