[SOVLED] Export a report as a PDF file from access

Anyone know how to do it?

I've been searching everywhere, and all i can find is code that explains how to do it with acrobat 5.

I've got VBA code that can change the default printer to the Adobe PDF driver, and back to the previous driver.

But it still comes up with the thing that asks what filename you want to export it to, which i can't figure out.

Any ideas?

Here is some code from one of my systems. It exports to a PDF file.

Set Report = crxApplication.OpenReport("Z:\DAD\CertificateofComplianceB.rpt", 1)
For Each crxDatabaseTable In Report.Database.Tables
crxDatabaseTable.ConnectionProperties("user id") = "sa"
crxDatabaseTable.ConnectionProperties("Password") = myPasswordTechniSQL
Next crxDatabaseTable
Report.ExportOptions.FormatType = crEFTPortableDocFormat
Report.ExportOptions.DiskFileName "C:\Certificate_of_Compliance_" & jobinx & ".pdf"
Report.ExportOptions.DestinationType = crEDTDiskFile
Report.Export False

Your code is for crystal reports. I'm using access, unfortunately.

Anyone?

You have to have Acrobat Writer inorder to do this.

I have got acrobat writer, its just i need to be able to set it to save to a filename i choose from code, instead of prompting the user to choose its filename.

You may want to try the Developer or Newsgroups on
the Adobe website. You can sign up for free to gain access, but to
get to the advanced stuff you need to subscribe for $$$.

Acrobat support

I figured out how to do it.

The trick is to forget about the acrobat PDF writer, its junk.

Download pdfFactory and use its printer driver and registry entries to export to a specific file. It also is a LOT faster than acrobat, and less buggy. Seriously adobe get your butt in gear.

Is anyone interested in how i coded it all in access?

Sure post the code! :thumb:

Here it is (in the first post)

Here it is (attached) - its an access 2000 file.

You need to download and install PDFFactory from here, as well:
http://www.fineprint.com/

Only costs $50us, and in my opinion works a million times better (less buggy, faster) than adobe.