Search results

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

I am running through it again with the extra line out. I remember taking a computer class in high school in the late-mid 70's. Using Fortran, creating simple mathematical equations on punch cards and waiting for the results. Funny how that is one of the classes that sticks in my memory more...

Of course! A query. Duh. Okay, so I got that to work, but if the URL is wrong, I get an error that there isn't a PDF to open because there wasn't one created, not that there was a URL error. I have a attached a document with screenshots of the error... I am correcting the URLs in the...

If the field is null, I just want to skip it. If the there is an error in the URL, then maybe a log or message at the end showing those records using a different field in the table as the identifier, i.e. Property. Does that make sense?

I have a few glitches to fix...maybe you could help. How do I get past a record that might not have a url or the url is invalid. The table I am using consists of all of our properties, whether we still own them or not. The url that I am accessing is a current site plan that we have on our...

Wow!! that works perfectly!!! Thank you!!!! Now I just have to figure out how to move it to my database. :)