Search results for query: *

ok. Thanks for your help. Janice.

Thanks for your advice but this won't work - from the webpage it calls Access passing in the name of a report and an ID. I need code (within a report) that calls each of my individual reports and prints them out to a file with a page break between each report!!

Good question! It would nee to be kicked off through the web page - as all the current reports are. But instead of just printing one report I want it to print all 20 reports. I don't want to have one main report full of 20 sub reports so I was hoping for a more subtle approach possible using...

I have several (complicated) reports which are run through a web front end - some of these reports also have subreports. I have had to use event procedures to get them to work. Now the client wants a button or similar to print out ALL the reports. Any ideas?? Thanks in advance.

Thanks Lekar. That does help.

Thanks you both for your help. Btw - I didn't design the dbase so can't avoid using row and column!

I want to produce a table of results - instead of having to write a separate query per value. The problem is I have two select statements bringing back the same value from a table but it doesn't distinguish from which select statement the value comes from - any advice would be appreciated. The...

Thanks again. I had tried something similar with a group header - the problem seems to be of there is no data in the sub report it never goes into the sub report so controlling the headers within the sub report doesn't work.

No, I can have 3/4 subreports per main report and they are not at the top of the main report. I have found a way to check from the main report to see if the subreport has no data but then what to do!

Thanks but I had already tried it that way - the problem is that if the subreport continues onto a second page the headers cannot be set to repeat. Any ideas???

If no data is returned in a subreport the column headers within the reports are not printed - I wish to force them to be printed. Is there anyway to do that in Access 2002?? Thanks.