Solved

OpenURL method

Posted on 2003-11-19
5
380 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
  • 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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
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…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

744 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now