How to ouput PDF formatted report to dir with VBA 3

[BMDE]

How do I output a PDF formatted report with VBA to a directory without a third party software?

Thanks is advance.

 

[mp9]

You don't, you need some form of third party software, whether it's something like Adobe Distiller or even if it's just something that acts like a print queue - take a look at cutepdf.com as a free example.

 

[THWatson]

As another alternative, I have been using pdfMachine, from Broadgun Software, for some time, and it is excellent. Free program from Broadgun.

All you have to do it print your report to it.

Tom

 

[pachad]

FYI,

You can set the default printer used for a report in the Page Setup dialog.

Also try PDF Creator on sourceforge:

http://sourceforge.net/projects/pdfcreator/

 

[BMDE]

I have been able to update Excel spreadsheets that are linked to Access from within Access. Without making any changes that I am aware of, the sheets are no longer updateable. I opened the sheets from Excel and they are not locked. I don't know what has changed. I tried relinking and they are still no longer updateable. I am told that there is no change to my privileges in the folder where the files reside.

Baffled.

 

[dhookom]

Just to add another great option to this thread, consider Stephen Lebans PDF writer at

http://www.lebans.com/reporttopdf.htm.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]