A simple way of doing this is to print it to a printer driver called
WIN2PDF. It is available form here:
http://www.win2pdf.com/?gclid=CLHorZDpqI8CFTaoGgodZ0a2SA
You use code to change the machines default printer to WIN2PDF, then you set
the file name, including the full path to the file, in the Registry. When
you print the report the file name setting in the Registry is cleared. The
setup file includes examples on how to do this.
You have to buy it, but I think the price was something like $30.
If you have Acrobat 5 (Not the reader, the full Acrobat) it comes with
PDFWriter which allows you to do the same thing, but PDFWriter has somwhat
limited graphics capability.
Probably for this reason, PDFWriter does not come with newer versions of
Acrobat.
For an Access report the limited graphics capability may not be a problem
though.
Note that PDFWriter is not included in the Acrobat 5 installation unless you
select it to be installed.
If you are interested I can give you some sample code for either printer
driver.
Ragnar
