Listbox values to Display in PDF

[Jerri via AccessMonster.com]

I know how to write my listbox selection to a word document. But, I do not
know how to do the same in PDF. How do I get the listbox selection to write
to a pdf.

Thanks,
Jerri

 

[Jack Leach]

Create a report of the Listbox data you want and use Lebans ReportToPDF to
export the file (or 2007 has an add-in available, I believe)

http://www.lebans.com/reporttopdf.htm

(one of the greatest peices of code ever written IMO)

--
Jack Leach
www.tristatemachine.com

"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)

 

[Kipp Woodard]

Access 2007 has PDF output.

DoCmd.OutputTo acOutputReport, "reportName", acFormatPDF, "filename"

 

[Jack Leach]

Access 2007 has PDF output.

DoCmd.OutputTo acOutputReport, "reportName", acFormatPDF, "filename"

I knew there was any easy way for 07. (I'm running 03)

thanks
--
Jack Leach
www.tristatemachine.com

"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)

 

[Mike Painter]

I know how to write my listbox selection to a word document. But, I
do not know how to do the same in PDF. How do I get the listbox
selection to write to a pdf.

PDF is something you "print" to. You basically are asking how to write your
selection to a printer and that requires a report.

 

[Jerri via AccessMonster.com]

Hi
I created the report and tried the code below from a button but received
popup box for output options of rich tex, data access, exce, text file, etc...
.. but none are the PDF option. I have this code in my button:

DoCmd.OutputTo acOutputReport, "rptpdf", acFormatPDF, "testfile"

Access 2007 has PDF output.

DoCmd.OutputTo acOutputReport, "reportName", acFormatPDF, "filename"

Create a report of the Listbox data you want and use Lebans ReportToPDF to
export the file (or 2007 has an add-in available, I believe)

[quoted text clipped - 9 lines]

 

[Jerri via AccessMonster.com]

to continue from my recent post... i just need the pdf to pop up with the
data from the report. please help with me with this.

thanks,

Access 2007 has PDF output.

DoCmd.OutputTo acOutputReport, "reportName", acFormatPDF, "filename"

Create a report of the Listbox data you want and use Lebans ReportToPDF to
export the file (or 2007 has an add-in available, I believe)

[quoted text clipped - 9 lines]

 

[Jerri via AccessMonster.com]

Am I missing something here?

I created the report and tried the code below from a button but received
popup box asking for output options of rich tex, data access, exce, text file,
etc...
but none are the PDF option. I have this code in my button:

DoCmd.OutputTo acOutputReport, "rptpdf", acFormatPDF, "testfile"

Access 2007 has PDF output.

DoCmd.OutputTo acOutputReport, "reportName", acFormatPDF, "filename"

I knew there was any easy way for 07. (I'm running 03)

thanks

Access 2007 has PDF output.

[quoted text clipped - 13 lines]

 

[Jack Leach]

Sorry, but I am not familiar with the OutputTo command.

You've verified the report and made sure that the path is fully qualified
(not a mapped drive, has file extension, etc.)

Other than that I think it should be a fairly straightforward command.

--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)

Am I missing something here?

I created the report and tried the code below from a button but received
popup box asking for output options of rich tex, data access, exce, text file,
etc...
. but none are the PDF option. I have this code in my button:

DoCmd.OutputTo acOutputReport, "rptpdf", acFormatPDF, "testfile"

Access 2007 has PDF output.

DoCmd.OutputTo acOutputReport, "reportName", acFormatPDF, "filename"

I knew there was any easy way for 07. (I'm running 03)

thanks

Access 2007 has PDF output.

[quoted text clipped - 13 lines]

Thanks,
Jerri

 

[Douglas J. Steele]

Have you applied all service packs for Access 2007?

Originally, the PDF option had to be downloaded separately (Adobe launched a
law suit), but I think it was integrated into one of the service packs.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Am I missing something here?

I created the report and tried the code below from a button but received
popup box asking for output options of rich tex, data access, exce, text
file,
etc...
but none are the PDF option. I have this code in my button:

DoCmd.OutputTo acOutputReport, "rptpdf", acFormatPDF, "testfile"

Access 2007 has PDF output.

DoCmd.OutputTo acOutputReport, "reportName", acFormatPDF, "filename"

I knew there was any easy way for 07. (I'm running 03)

thanks

Access 2007 has PDF output.

[quoted text clipped - 13 lines]

Thanks,
Jerri