Recent content by ksimpson61

I understand. The page break isn't the issue as there is mostly always a first image, so I need to keep the sub report visible. It is the second image that only applies to a few records, but I have to include the second image box in the sub report in case there is one. Maybe I can try to...

I don't see any event options for page breaks.

That's what I have and it doesn't work. That's why I thought I could call in the image box at the time the report is being formatted...setting the size of the image box at the time so that it isn't already established in the sub report.

I have a sub report that is used only to display either one or two images for the selected record. Each image fills a full page. It worked great when I only had one image except that if a particular record does not have an image, there is one blank page in the report. But adding the second...

I finally got it to work!!! I saved the original Redimensionar code in Spanish and pasted it into the Convert PDF Code module, then placed your code (except for the Sub line and exit Sub) just after the creation of the jpg. I used sPath = Replace(PDFPath, ".pdf", "_page_2.jpg") in the code to...

I am still confused. Do I need to translate the code, or just paste it into my database in Spanish? Where do I paste it? In a new module? or is it a class object? Disregard this post...

The pdf's are created when the url is downloaded, which is all in the code. I have changed the folder where the pdfs and jpgs will save to wherever the database is located. The URL's should work, but if you don't have Adobe Acrobat, and enable the Acrobat Library, I don't think the process...

Thank you! However, I am too new at this to know how to apply it to my existing code. Of course, my translation may be wrong too. I added the code and then tried to use Resize () in the loop, but I am getting an error - argument not optional. When I try to put in additional arguments, i.e...

Unfortunately, there was not a way to open the pdf in the subreport. I had to convert it to an image in order to view it.

I was fortunate to receive help recently on downloading a pdf's and converting them to jpg's. However, some of the images are distorted when they open in the image control in the report. I thought that maybe there was a way to set the size of the image when I am saving them after the...

I'll leave the code in. You never know, it could happen, but I'm not going to worry about how long it takes if it happens so seldom. Thanks again for all your help!!!

Oh, and I'm not getting any messages.

Got it. You're right. They are two different issues. Since none of my URL's were actually bogus, I didn't run into that problem, so I couldn't test it. When I run your database it takes less than a minute to process. I just looked at the time stamps on the files, and they were all 2:04.

I don't know why, but if the URL was wrong, it was not the full URL, just a couple of reference numbers. For example, the following is an actual URL. http://rpai.propertycapsule.com/property/output/document/view/id:4378/?time=1474647894/ When the process didn't work, there was an error in the...

So, I was able to insert code into the Sub SavePDFas JPEG in which it checks to the size of the pdf file. Since the file was being created, it just couldn't open when the webpage was wrong. 'Check size of the input file. If FileLen(PDFPath) > 0 And FileLen(PDFPath) < 1000 Then...