Possible to export report to rich text with pages saved based on a field?

[CSP12345]

Morning all,

Just wondering does anyone know if it possible to export a report of numerous pages to a rich text and have the pages export separately with a name based on a field?

1. page 1. save as item code based on an item code field
2. page 2. save as item code based on an item code field

currently if I bring up the report on the selected criteria I only know how to export the whole lot of pages into one document.

Hope that makes sense?

 

[Micron]

1. page 1. save as item code based on an item code field
2. page 2. save as item code based on an item code field

You don't know that the filtered results of the report are on any particular page or range of pages, correct? So I presume you want to output a portion of a report (which is based on a query or table) based on some criteria. Then why not use the Docmd.OutputTo method to output the filtered query or table as an rtf file? It would probably be easier if a form provided the filter/criteria value and a query referenced the form control as criteria. You could then output the query each time a form command button was clicked. Or I presume that in vba, you could create a query def inside of a loop and output the query def. You can also set the record source for a report at run time and output a filtered report to rtf. More than one way to skin this cat.

 

[CSP12345]

The report is based on a filtered set of dates returning 1 page per result, if I were simply to export to rtf or even print to PDF the exported will be 1 file, I am looking to create separate files with the name being derived by a field?? Is that possible?

 

[Micron]

Yes. I'd create a record set and loop through it, exporting the report and use the field value as the file name, once for each record in the record set. If you need help, you'll have to provide more information about the report's underlying record set and where the date values are coming from. I have no idea if the date and name data comes from the report query or separate places. Nor do I know if the report is filtered by some form control such as a textbox or combo box holding a date value.