Programmatically sending Access Reports to PDF

[Alan Searle]

I have a function that outputs reports to HTML (i.e. the same report
filtered for each recipiant and then a separate report generated for
each recipiant). This works fine but, of course, the formatting is a
bit chaotic.

We have Acrobat writer/distiller 6.0 installed which seems to contain a
whole stack of calling options (documented in the disparam.pdf help
file) but I can only find examples of using this with Word and with Excel.

In the past I have got this working by dynamically changed the acrobat
registry/ini settings but my current client has locked down the registry
so this path is blocked to me.

Together with colleagues and I have got a mechanism working but it
involves a lot of user-intervention and 'send-keys' (arrgghh) so I am
hoping that someone out there has a snippet of code for me to adapt?

I have googled the internet for examples but everytime I find something
interesting, I get asked for my credit card details (arrgghh).

Any tips would be a great help.

Regards,
Alan Searle

[DC]

Check out http://ourworld.compuserve.com/homep...cg/acgsoft.htm

I have not used this tool but looks pretty cool to me for $55.00

"Alan Searle" <aj*******@xxxxyahoo.com> wrote in message
news:co**********@newsreader2.netcologne.de...

I have a function that outputs reports to HTML (i.e. the same report
filtered for each recipiant and then a separate report generated for each
recipiant). This works fine but, of course, the formatting is a bit
chaotic.

We have Acrobat writer/distiller 6.0 installed which seems to contain a
whole stack of calling options (documented in the disparam.pdf help file)
but I can only find examples of using this with Word and with Excel.

In the past I have got this working by dynamically changed the acrobat
registry/ini settings but my current client has locked down the registry
so this path is blocked to me.

Together with colleagues and I have got a mechanism working but it
involves a lot of user-intervention and 'send-keys' (arrgghh) so I am
hoping that someone out there has a snippet of code for me to adapt?

I have googled the internet for examples but everytime I find something
interesting, I get asked for my credit card details (arrgghh).

Any tips would be a great help.

Regards,
Alan Searle

[Norman Scheinin]

You can create a report and set the print option | Printer to Acrobat
distiller.

Alan Searle wrote:

I have a function that outputs reports to HTML (i.e. the same report
filtered for each recipiant and then a separate report generated for
each recipiant). This works fine but, of course, the formatting is a
bit chaotic.

We have Acrobat writer/distiller 6.0 installed which seems to contain a
whole stack of calling options (documented in the disparam.pdf help
file) but I can only find examples of using this with Word and with Excel.

In the past I have got this working by dynamically changed the acrobat
registry/ini settings but my current client has locked down the registry
so this path is blocked to me.

Together with colleagues and I have got a mechanism working but it
involves a lot of user-intervention and 'send-keys' (arrgghh) so I am
hoping that someone out there has a snippet of code for me to adapt?

I have googled the internet for examples but everytime I find something
interesting, I get asked for my credit card details (arrgghh).

Any tips would be a great help.

Regards,
Alan Searle