Solved

OpenURL method

Posted on 2003-11-19
5
390 Views
Last Modified: 2012-05-04
Hi I found a way to retrieve binary file from URL with this method in vb but I can't find the way to use it in access.
Someone can help me, give me an example?


http://support.microsoft.com:80/support/kb/articles/Q163/6/53.ASP&NoWebContent=1
0
Comment
Question by:meciab
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 9

Expert Comment

by:svenkarlsen
ID: 9777361
Hi mecia,

first of all: you are aware that this is just usning a form in Access to do what you can much better do with Internet Explorer ? I.e.: this is not a 'function' it is an ActiveX object that you put on a form, and then click a button for operation.

If I am right in assuming that you want to do FTP from code, I suggest you have a look here instead:

 > http://www.vbip.com/winsock/index.asp

This is a really good source and explains everything, including some of the stuff that Microsoft doesn't document!

Kind regards,
Sven
0
 

Author Comment

by:meciab
ID: 9777478
No I just want to use this function in access, but i cannot find the way to reference OpenUrl method.

Function test()
Dim b() As Byte
Dim strURL As String
Dim SavPath As String

strURL = "http://experts-exchange.com/images/logo.gif"
SavPath = "c:\"

    b() = Inet1.OpenURL(strURL, icByteArray)
    'Write the image to a local file:
    Open SavPath & "test.jpg" For Binary Access _
    Write As #1
    Put #1, , b()
    Close #1

end function
0
 

Author Comment

by:meciab
ID: 9777541
Yopssssss.....
I found the answer to my question the reference to add is MSinet.ocx (Microsoft Internet Tranfer Control)
Thanks for your help
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 9802978
PAQed, with points refunded (500)

Computer101
E-E Admin
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Fields don't match on a query 9 40
Access creating new db - relationships 8 50
Handle Apostrophes in SQL Parameter 16 61
Compress Newid value ms sql Mssql 4 41
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question