Chaps I have been scouring the web and the so far have found the
following outlined method the best by far when creating PDF's in
msaccess, and its open source.
See the following websites
You need to install ghostscript and redmon
http://masterdev.dyndns.dk/know/freepdf.html http://stat.tamu.edu/~henrik/GSWriter/GSWriter.html
You are essentially creating your own PDF writer, you can also combine
this with the program called pdftk which can combine PDF's thru the
command line.
What I do is save all my pdf as c:\tempoutput\tmp.pdf, loop thru
printer queue until the pdf printer has finished, then use the msaccess
vba to rename file. If I have a multi file PDF I have a form the user
ticks to gret pdftk to combine them. The other day I combined a letter,
4 page schedule and a map into one PDF and sent to client it was quite
well received.
