Access vba download url

Maybe try API function. See Gustav answer in stackoverflow. Does this answer your question? See codeproject. Review stackoverflow. Thank you June7 for the recommendation. I tested the code from stackoverflow. Add a comment. Active Oldest Votes. Improve this answer. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. Dim strSql As String.

Execute strSql. While Not recd. Execute strQuery. Open Table again to view the insrted data. OpenTable "tblCustomers". SelectObject acTable , "tblCustomers". Save form vba code. Access : Click Command Button. VBA : Error Type not defined. Access : Add reference. Access : Open the table. Like this: Like Loading The function returns the long name of the cached file see inline comments for an example for you to use to display the image.

All you store in your database is the full URL of the image and this function does the rest and returns the file name for you to assign to a picture control. If you run the function before opening your form or report, you can retrieve the file names of the cached files to be displayed without worrying about folder or file names. Should the user or some clean-up procedure clear the cache, all that happens is that, when the form or report is opened again, the picture files will once more be downloaded and cached.

Further, when the pictures are cached, the form or report can still be displayed should the user or the source go off-line. For both of the above scenarios, specifically the latter, you can actually let the form or report handle the download automatically before it is shown to the user. Typically, these are implemented to carry out various custom calculation tasks that are impossible or too cumbersome to implement in pure SQL.

However, a UDF can do any task that a function can do, including if you need to have some action for every record, which is what we're after here: Download a picture for every record. This must be taken care of, if you retrieve the URL directly from a hyperlink field.

Luckily, there is a native function of Access to handle this:. So all that is needed for the form or report to automatically download and cache any given picture file, is to change the record source from, say:. And to save the images permanently versus caching in a predefined folder, just pass the folder to the function as the third argument see inline code comments :. You may notice the identical cached folder name is used for the form and the report.

The file has only been downloaded once and the same image is retrieved from the cache. As you can see, either a form, a report or both can be turned into what the user will experience as an online form or report. The pictures will be retrieved silently before the form or report is displayed. Full code running in both and bit version of Access and samples of both reports, a normal form, and a continuous form is attached for Access : PictureUrl.

All pictures are courtesy of: World Flag Database. I hope you found this article useful. You are encouraged to ask questions, report any bugs or make any other comments about it below.

Note : If you need further "Support" about this topic, please consider using the Ask a Question feature of Experts Exchange. I monitor questions asked and would be pleased to provide any additional support required in questions asked in this manner, along with other EE experts. Please do not forget to press the "Thumbs Up" button if you think this article was helpful and valuable for EE members. Have a question about something in this article? You can receive help directly from the article author.