Images from URL on Reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I was just wondering how to display an image from a URL in a field on a
report in Access.

The field on the report contains the full URL to the image, but i cannot
make the actual image itself appear on the report.

Im using access with SQL server so i cant chose to make it an OLE object
type either.

Thanks
 
Here's a previous post of mine on this subject:

Newsgroups: comp.databases.ms-access
From: "Stephen Lebans"
<[email protected]> - Find
messages by this author
Date: Mon, 13 Sep 2004 01:53:23 GMT
Local: Sun, Sep 12 2004 6:53 pm
Subject: Re: Is it possible to programatically save a certain image from
a certain web page?
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Report Abuse

You're probably better off asking your question in one of the Visual
Basic NG's or if you search GoogleGroups you'll surely find some
relevant code examples.
Here's aprevious post of mine on this subject:


From: Stephen Lebans
([email protected])
Subject: Re: Images on an Access Form


View this article only
Newsgroups: microsoft.public.access.formscoding
Date: 2004-05-23 19:58:06 PST


Hi Allen,
I have never worked in this area before so I just had a quick peak at
the issue tonight. You cannot place a URL in the Picture prop of a
standard Access Image control so it's either use the Hyperlink method
you outlined or some method to download the image to your local disk and
then load that image intot he Image control.


I placed the MS INternet Transfer control on an Access Form. I added a
CommandBUtton and an Image control.


Private Sub cmdDload_Click()
On Error GoTo Err_cmdDload_Click
Dim sUrl As String
sUrl = "http://www.lebans.com/images/Hillcrest 4x5grey.jpg"


Dim binarydata() As Byte


binarydata() = Me.ActiveXCtl1.OpenURL(sUrl, icByteArray)


Open "C:\TEMP\image.jpg" For Binary Access Write As #1
Put #1, , binarydata()
Close #1


Me.Image3.Picture = "C:\temp\Image.jpg"


Exit_cmdDload_Click:
Exit Sub


Err_cmdDload_Click:
MsgBox Err.Description
Resume Exit_cmdDload_Click


End Sub





--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Hi,

Thanks for that Stephen, I was wondering if you could paste the details about

"You cannot place a URL in the Picture prop of a
standard Access Image control so it's either use the Hyperlink method
you outlined "

I've tried google and several messageboards and no one seems to have any
ideas on this problem.

Thanks!

James

Ja,e
 
THe quoted post is from the MS Forms NG. The Hyperlink method applies to
Forms not reports.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Back
Top