retreive image using image source

[n8kindt]

i have linked a mySQL database (that populates data in our webstore) with my Access 2007 database. i want to be able to see the images in access also. however, i only have a referring url to work with. can i have access retreive an image and place it into a form/report using only a url?

UPDATE:
just had an idea. i think an activeX control would work wouldn't it? i have no idea where to start with that tho. help please? thanks all.

[wassimdaccache]

i have linked a mySQL database (that populates data in our webstore) with my Access 2007 database. i want to be able to see the images in access also. however, i only have a referring url to work with. can i have access retreive an image and place it into a form/report using only a url?

UPDATE:
just had an idea. i think an activeX control would work wouldn't it? i have no idea where to start with that tho. help please? thanks all.

Hi

I'm not expert user but I did it in my project and it is working well. The idea is to save the name of your picture in a table and then you can you insert a picture in your form and then you can change the caption of the image by declaring the root of the picture you want. I can provide you more details if you see this idea is helpful for you.


Please experts give us your feedback if my advice is good


have a nice day


WASSIM S DACCACHE

[n8kindt]

Hi

I'm not expert user but I did it in my project and it is working well. The idea is to save the name of your picture in a table and then you can you insert a picture in your form and then you can change the caption of the image by declaring the root of the picture you want. I can provide you more details if you see this idea is helpful for you.


Please experts give us your feedback if my advice is good


have a nice day


WASSIM S DACCACHE

thanks for the quick reply. hmmm i'm not exactly sure if i follow you. but if i do, you are saying i need to make a separate table with columns that contain the itemID and the referring url... then perform the procedure you described and relate it with a query? if that is the case, then i would have to run a query that modifies the table data each time a product in our store is added or an itemID is modified. i plan on handing the duty of updating and adding new items to someone else but this might require some expertise on their part (or at the very least a quite a bit of programming) to do. this could work, but i am looking for a more simple answer.

[n8kindt]

still looking for an answer to this question. i haven't been able to find any information on this anywhere

[ADezii]

You can use the Microsoft Web Browser Control (ActiveX Control) to Navigate to a specified URL representing a Graphic Image as follows:
[CODE=vb]
Dim strURL As String

strURL = "http://www.commissarie s.com/news/news_2007/images/fruit.jpg"

Me![ActiveXCtl8].Navigate strURL[/CODE]

[n8kindt]

You can use the Microsoft Web Browser Control (ActiveX Control) to Navigate to a specified URL representing a Graphic Image as follows:
[CODE=vb]
Dim strURL As String

strURL = "http://www.commissarie s.com/news/news_2007/images/fruit.jpg"

Me![ActiveXCtl8].Navigate strURL[/CODE]

worked like a charm! thanks ADezii!!!!

[ADezii]

worked like a charm! thanks ADezii!!!!

You are quite welcome.