Search results

I didn't bring my computer home from work so I'll have to wait until the morning to give it a try. Thank you so much!!!

So, when I first ran it "out of the box" I received an error from Adobe Acrobat, "There was an error opening this document. This file cannot be found." And an error from Microsoft Visual Basic "Run-time error '91': Object variable or With block variable not set. I made my changes in step-wise...

Almost there.... So I changed the file path and was able to download all three of the pdfs. I also added some code to the module to convert PDF Code so that it could find the downloaded file. Then the process converted the first document. I tried to add the Do While not rs.EOF , rs.MoveNext...

Thanks! Let me know if you do because it's beyond my knowledge base (which is pretty basic).

Yes, I do have Adobe acrobat, not just reader. The URLs are webpages, unfortunately, not a path to a local drive.

here is the link to the code: 'http://www.myengineeringworld.net/2013/03/vba-macro-to-convert-pdf-files-into.html It is assuming a local path to open the pdf and then convert it to various file types.

I have a table that has a text field for a URL. The URL is a pdf and I would like to save this pdf as an image (jpg or gif, doesn't matter). I have about 180 records in the table so I need to set up a loop that will go through each record, open the url, convert to image and save the image to a...

Yes, I'm still having issues. I have been playing around with how the file was saved, named, etc. If I use a different image that works and rename it to an image that wasn't working, it works. So it must be the image, right? However, I played around with one of the non-working images and...

JHB - I re-ran some reports and found that the missing images are not random. It seems to be the same images that are missing, assuming it is a multi-unit report. However, when I pull up a report of only images or if I pull up the full report but for only one unit, the image shows up. That...

Ranman256 - That's what I thought. I put it in the correct place. Thanks for your help.

In response to JHB...the missing images are random. Not always the same one(s) and the size of the picture file(s) doesn't seem to matter. I checked the report I ran yesterday and there were pictures that were over 1,000 KB generated, but some that were around 750 KB that were missing.

Thank you for your response. I tried the inputting the following in the On Print event in the detail section of the subreport where the imagebox is located: [ImgBxSitePlan]=[SitePlanName] Where ImgBxSitePlan is the name of the image box and SitePlanName is the field where the image path is...

I have a report that pulls information for each unit. I have set up a filter so that the user can pull a report for one unit or several units based on region. Each unit's report is about 5 pages with the last page being a jpg of a site plan. If I pull the report up with more than just one...

Thank you for your response. What I am looking to do is open the web pdf file within an Access report and view it in print preview mode, not separately in Acrobat. Although the full report might be exported to pdf after I have reviewed it, it may also be sent directly to the printer.

I have a report in which I created an image control where the source is a text field with the path to a jpg file. The problem is I would like to use a hyperlink to the original pdf so I don't have to always update my jpg file when the image is changed by our Marketing team. I tried to add...

I just registered, but have found help in this forum in the past. Thank you! I started working in Access in 1998 and have dabbled ever since. I really like to use Access whenever I can, but find it's not always easy to find support for it in the workplace. I am now working for a company that...