Save the output of a report ...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a need to schedule an access report using macro and
save the output of report to a file.
I didn't find anything on how to save the output of a report to a file.
Can someone share their experience with me?

Thank you,
-Me
 
Hi You ;-)
I am planning to do the same.
I was thinking of printing using the printer AcrobatPDF in the list of my
printers.
This PDF generator creates a PDF file. The name of the file, by default, is
the name of the report.
I did'nt find yet how to tell Access to use AcrobatPDF in the list of my
printer, and I don't want AcrobatPDF to be my printer by default.
If you don't have AcrobatPDF in the list of your printer, you can download
PDF995 or other free PDF generators. Upon installing these, you will have a
new printer in your list of printers and this printer, instead of printing,
will create a PDF file.
Hope I did help,
Céline
 
Hi,

You should have a macro command choice of "Output to". You can select
how you want your output saved (html, excel, rtf, etc.).
 
Thank you Celine,

I will try it out.
-Me


Céline Brien said:
Hi You ;-)
I am planning to do the same.
I was thinking of printing using the printer AcrobatPDF in the list of my
printers.
This PDF generator creates a PDF file. The name of the file, by default, is
the name of the report.
I did'nt find yet how to tell Access to use AcrobatPDF in the list of my
printer, and I don't want AcrobatPDF to be my printer by default.
If you don't have AcrobatPDF in the list of your printer, you can download
PDF995 or other free PDF generators. Upon installing these, you will have a
new printer in your list of printers and this printer, instead of printing,
will create a PDF file.
Hope I did help,
Céline
Click to expand...
 
Hi Chris,
Thank you for this suggestion.
Do you think it is possible to add the PDF format to the list ?
Céline
 
Back
Top