Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Mar 2006
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    289
    Thanks
    0
    Thanked 1 Time in 1 Post

    My dilema (2003 sp3)

    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?
    Thanks
    chuck

  2. #2
    3 Star Lounger
    Join Date
    Mar 2006
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    289
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: My dilema (2003 sp3)

    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.
    Thanks
    chuck

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: My dilema (2003 sp3)

    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.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: My dilema (2003 sp3)

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •