Programatically printing Access reports from pdf995 using VBA

[gudia]

I want to Programatically generate Access reports in the pdf format
using some tool and then email them to people in the same code. Right
now I am trying to do this with pdf995 using VBA (emailing is a
separate issue, which pdf995 does not addresses).

I downloaded pdf995. It controls printing via pdf995.ini file. In the
VBA code, I have DoCmd.OpenReport "Report2", acViewNormal. I am having
the following problems right now.

(a) I do not understand how the .ini file is used with printing.
Specifically, when I issue the command DoCmd.OpenReport "Report2",
acViewNormal
what should I expect? Right now, all this command does is send the
report to the printer, which this line of code would do, WITHOUT
pdf995. In the e:\temp folder, pdf995 does not generate anything.

(b) I want to avoid sending reports to the printer. How will I
accomplish this?

(c) No dialog boxes of any kind (Save as etc.)

I have already looked at FAQs and Developers FAQs at pdf995 web site.
Yes, there is a VB sample. But it does not address the problems I am
having.

I have looked at other postings. Immediately after the above command,
people say to use CopyFile_TSB function (to copy the output generated
by the execution of the DoCmd.OpenReport command to the filename you
want). My problem is which command (could somebody give me an example)
generates the pdf file using pdf995?

Here is my pdf995.ini file.

[Parameters]
Output File=SAMEASDOCUMENT
Output Folder=e:\temp
Autolaunch=0
[Debug]
EndDocPort1=1
EndDocPort2=1
EndDocPort3=1

Help appreciated.

If somebody has a better method, please advise.

Thanks

[Robert Allyn]

The Acrobat SDK has some sample code to do this (at least the v5.0 one
did, and I am sure v6.0 does as well)
http://partners.adobe.com/asn/acrobat/download.jsp

- Robert
On 23 Jun 2004 08:35:23 -0700, gu*****@yahoo.com (gudia) wrote:

I want to Programatically generate Access reports in the pdf format
using some tool and then email them to people in the same code. Right
now I am trying to do this with pdf995 using VBA (emailing is a
separate issue, which pdf995 does not addresses).

I downloaded pdf995. It controls printing via pdf995.ini file. In the
VBA code, I have DoCmd.OpenReport "Report2", acViewNormal. I am having
the following problems right now.

(a) I do not understand how the .ini file is used with printing.
Specifically, when I issue the command DoCmd.OpenReport "Report2",
acViewNormal
what should I expect? Right now, all this command does is send the
report to the printer, which this line of code would do, WITHOUT
pdf995. In the e:\temp folder, pdf995 does not generate anything.

(b) I want to avoid sending reports to the printer. How will I
accomplish this?

(c) No dialog boxes of any kind (Save as etc.)

I have already looked at FAQs and Developers FAQs at pdf995 web site.
Yes, there is a VB sample. But it does not address the problems I am
having.

I have looked at other postings. Immediately after the above command,
people say to use CopyFile_TSB function (to copy the output generated
by the execution of the DoCmd.OpenReport command to the filename you
want). My problem is which command (could somebody give me an example)
generates the pdf file using pdf995?

Here is my pdf995.ini file.

[Parameters]
Output File=SAMEASDOCUMENT
Output Folder=e:\temp
Autolaunch=0
[Debug]
EndDocPort1=1
EndDocPort2=1
EndDocPort3=1

Help appreciated.

If somebody has a better method, please advise.

Thanks

[Antony Garnett]

If it helps....

I use PDF995 and PDF995 Edit. I set the Edit application to
automatically save and name the report. I then set the report to print
specifically to the PDF995 using the Page Setup options. When I use
the DoCmd.OpenReport "rpt..." it creates the pdf file using the
Caption Title of the report. I then issue an email command to send the
pdf.

Not sure whether this is a solution for you but if it is let me know
at an****@asg-solutions.co.uk

[Alex]

I use the PDF class from Attac Consulting. It was well worth the money.
http://ourworld.compuserve.com/homep...cg/acgsoft.htm

an****@asg-solutions.co.uk (Antony Garnett) wrote in message news:<fa**************************@posting.google. com>...

If it helps....

I use PDF995 and PDF995 Edit. I set the Edit application to
automatically save and name the report. I then set the report to print
specifically to the PDF995 using the Page Setup options. When I use
the DoCmd.OpenReport "rpt..." it creates the pdf file using the
Caption Title of the report. I then issue an email command to send the
pdf.

Not sure whether this is a solution for you but if it is let me know
at an****@asg-solutions.co.uk