By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,464 Members | 1,164 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,464 IT Pros & Developers. It's quick & easy.

Programatically printing Access reports from pdf995 using VBA

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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


Nov 13 '05 #2

P: n/a
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
Nov 13 '05 #3

P: n/a
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

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.