I have pursued and tried to understand the various “fragmented” solutions, advice and work a-rounds currently on file, but none provide a clear “Step by Step” coding solution for my problem which is:
A solution using MS Access (2003) Forms, Reports and VBA code etc. that will enable a User to open a "Print report" form dialog box with a “Print, save and email” option that will Automatically, background print the selected report directly to Adobe Acrobat Writer .pdf (V.6) and which will automatically (without any further user input) create (if new) and or save the pdf document using information (Drive Name, Path, Folder Name and File Name) pulled from a reference table with the current MS access database.
I am glad its working for you,
Color and Resolution (dpi) depends on the postscript printer you choose,
so, Yes color is an option.
jaffer