My dilema (2003 sp3)

Topic

New Reply

I have used Stephen Labens ReportToPDF function successfully many times, but only to create single files. This time I needed to loop through a list of report names (10). The strange thing is I always get the first file and then a message saying “Output To is not available now” and it hangs in the ReportToPDF function. If I step through the code once and then run it I get all 10, or if I step through once, stop the run and then trigger it again from the command button it prints all 10. But If I run from the button immediately after it fails again giving me only one report.

Does this ring any bells?

Reply | Quote

Replies

I copied everything into a new database and ran the code successfully three times. I have not been able to do that in the recent past. I guess something had gotten corrupted.

Reply | Quote

Glad you got it to work. Post back if the problem returns.

Reply | Quote

I use that also, but I’ve never tried to print reports back-to-back before like that. I don’t know how the function assigns names for the intermediate .SNP file, but it almost sounds like it is using the same filename each time, and it hasn’t finished with the first report before the 2nd one starts.

Reply | Quote