Creating Multiple File Names From an Access Report

[philgaeta]

I need to create multiple files for each page of a microsoft access report. I would then like to name the files based on text contained within the access report. The report that I am attempting to use is based on a query that allows the user to select a date range to return. Using the OutputTo macro, I have the file saved to a RTF so that it can be e-mailed and uploaded to a web server. Each filename needs to be unique and the records are set up to return 1 record for each report page which signals a new file. Any suggestions?

Thank You

 

[GoDawgs]

If you are page breaking right now to create new pages then you can loop through a recordset and run the report with specific criteria (so it returns only one page), each time saving the report as a different name:

1. Set up specific criteria to limit the report to one page
2. Open the report
3. Export and rename
4. Repeat for each instance of the criteria you created.

Hope that helps.

Kevin

 

[philgaeta]

Oh. I only wish that it were that simple. See what I would like to do is to automate the report. As data is entered by the users each day I need the database to store a unique filename in a network directory. Within my report, each record generates a 1 page word document (Much Like an Invoice) which is e-mailed and loaded to a web server. These files need to be uniquely named and I would like to make this a "No Touch" process with the naming convention derived from data on the report. Any advice?