Does anyone know how to link Access to Yahoo IM?

J

Jason McAdams

Is there a control in MS Access forms that will allow me to put in the web
address of a picture and have that image display on the form when viewed?
This control would need to be able to take part of the hyperlink from
another field in the same record (e.g.
http://www.microsoft.com/images/IMAGENAME.GIF where IMAGENAME.GIF is the
name of the image file which is in another field in the record.

What I'm ultimately trying to do is link Access to Yahoo IM. I'd like to
have Access report if a Yahoo IM user is online at any given moment (in a
form or report). I can get an online/offline GIF from the internet by using
the user's IM name in the hyperlink, but I can't get Access to pull a
picture from the internet anywhere. Any other ideas would also be
appreciated. I really don't even need a picture. A Yes/No field would work
fine too if I could find a way to do it.
 
A

Arvin Meyer

There is a Web Browser control that will display a page (or image) from an
internet web page. Assuming the hyperlink path is stored in a text field and
displayed in a textbox named txtURL, do something like:

Private Sub cmdNavigate_Click()
If Not IsNull(Me.txtURL) Then
With Me.ActiveXCtl0
.Navigate Me.txtURL
End With
End If
End Sub

When you click the command button (cmdNavigate) it will take you to the web
page or image.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
J

Jason McAdams

This is great - works dandy. The only thing is, I'd like this image to show
up next to every record at all times. This forces me to have to click the
navigate button (I just set the 'On Focus' event for the control so I didn't
have a separate button) for each record - and then the webpage will be
turned off for the previous record. Is there a way to get the whole form
(or report) to populate automatically? Thanks for you help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top