I have been using Lebans code to print a report to PDF. This it does superbly.
The database itself is very simple and consisits of just a few fields in one table.
Essentially it is a list of 'equipment' and their 'location'. There are a few other fields but nothing major. In the report I have inserted the 'Location' field into the page header and set the Force New Page property to Before Section so that the location header title appears only once when the records spill over a single page. It gives me a nice report with a list of equipment separated into 'location' pages.
I have trawled the net to try and undersatnd how to code my database to print each 'Location' as a separate PDF with the file name as the location. Currently Leban code does a fantastic job but just prints it as one file with the report title as the file name.
I am about two steps from some form of institution and also a little punch drunk trying to get my head around it.
Any help would be great.
Cheers
The database itself is very simple and consisits of just a few fields in one table.
Essentially it is a list of 'equipment' and their 'location'. There are a few other fields but nothing major. In the report I have inserted the 'Location' field into the page header and set the Force New Page property to Before Section so that the location header title appears only once when the records spill over a single page. It gives me a nice report with a list of equipment separated into 'location' pages.
I have trawled the net to try and undersatnd how to code my database to print each 'Location' as a separate PDF with the file name as the location. Currently Leban code does a fantastic job but just prints it as one file with the report title as the file name.
I am about two steps from some form of institution and also a little punch drunk trying to get my head around it.
Any help would be great.
Cheers