Converting a Report to PDF (2007)

[noclueforid]

Hello again!

I have a report that contains information from four different queries. Each of those four queries prompts the user to enter a date range to find the records needed. When I open the report, it prompt the user for these date ranges, then populates the report accordingly. All is fine.

Now, when I go to save that report as a pdf document, it requests those same date ranges again. Is this normal or is there a way to skip the report view, and once the user clicks a button, it automatically runs the report, then saves it as a pdf document? I tried to set the macro assigned to the button to "Print Preview" instead of "Report", but you still have to enter the date ranges twice. I looked for some code examples of automatically creating a pdf, but couldn't find any.

Thanks!

[jimatqsi]

When I have that situation I launch the report from a form. The form asks for the needed parameters, stores them in a local parameter table and then I join the parameter row into the query. Or you could simply reference the

Forms!frmname!txtParametername

in your query and forget about saving the parameters in a table.

For auto pdf creation, see this page. Not sure if this still works if you are using Access 2010.

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

[noclueforid]

Thanks, Jim.

I tried that and it worked OK, but in the process came up with another solution to just output it directly to pdf using the following code:

 DoCmd.OutputTo acOutputReport, "rptInvoicingIOC", acFormatPDF 

Thanks for your suggestion!

[NeoPa]

I've updated the title to reflect that you are using Access 2007 or later. This is always important, but especially so when asking about facilities introduced in a particular version.

Stephen Lebans' code is only required for versions 2003 and earlier. Otherwise the facility is included as standard in Access.