Hi.

I have a need to create a PDF file from within an MS Access report (within
the Access VB code).

I am trying to use the Adobe6 Professional tools to do this... but not sure
how.

I am getting a filename prompt when I use this, but I actually just want to
pass it a file name.

Does anyone know how to do this?

Alternatively, I can currently created a .rtf file from within Access.
Perhaps there is a command line tool (or API) that I can call from within
Access VB code that will do something like this....

   mygreatepdfapp.exe -ic:\myreport1.rtf -oc:\myreport1.pdf
....this would result in the file c:\myreport1.pdf.  Is there such a thing?

Ultimately, I just dont want any prompts when generating these files, so I
am willing to try anything.

Thanks

On Tue, 13 Jul 2004 06:10:08 GMT, Disco Octopus wrote:

> Hi.
> 
> I have a need to create a PDF file from within an MS Access report (within
> the Access VB code).
> 
> I am trying to use the Adobe6 Professional tools to do this... but not sure
> how.
> 
> I am getting a filename prompt when I use this, but I actually just want to
> pass it a file name.
> 
> Does anyone know how to do this?
> 
> Alternatively, I can currently created a .rtf file from within Access.
> Perhaps there is a command line tool (or API) that I can call from within
> Access VB code that will do something like this....
> 
>    mygreatepdfapp.exe -ic:\myreport1.rtf -oc:\myreport1.pdf
> ...this would result in the file c:\myreport1.pdf.  Is there such a thing?
> 
> Ultimately, I just dont want any prompts when generating these files, so I
> am willing to try anything.
> 
> Thanks

What I have done in the past is to print to a file using a postscript
printer driver.  Instead of FILE: as the port, I set up a local port as
"C:\TEMP\REPORT.PS". Then I shell to ghostscript to convert to PDF.  No
prompting required.

mygreatepdfapp.exe -ic:\myreport1.rtf -oc:\myreport1.pdf

What year is this? I have not used a command prompt like that since 1984!!!

Dunkie wrote:
> mygreatepdfapp.exe -ic:\myreport1.rtf -oc:\myreport1.pdf
>
> What year is this? I have not used a command prompt like that since
> 1984!!!

right. ok. but this is the kind of behaviour that i require, as there are no
other possible ways (that i have found yet) to do this.