By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,998 Members | 2,903 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,998 IT Pros & Developers. It's quick & easy.

retreive image using image source

n8kindt
100+
P: 221
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.
May 14 '08 #1
Share this Question
Share on Google+
6 Replies


100+
P: 222
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
May 14 '08 #2

n8kindt
100+
P: 221
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.
May 14 '08 #3

n8kindt
100+
P: 221
still looking for an answer to this question. i haven't been able to find any information on this anywhere
Jun 8 '08 #4

ADezii
Expert 5K+
P: 8,638
You can use the Microsoft Web Browser Control (ActiveX Control) to Navigate to a specified URL representing a Graphic Image as follows:
Expand|Select|Wrap|Line Numbers
  1. Dim strURL As String
  2.  
  3. strURL = "http://www.commissaries.com/news/news_2007/images/fruit.jpg"
  4.  
  5. Me![ActiveXCtl8].Navigate strURL
Jun 8 '08 #5

n8kindt
100+
P: 221
You can use the Microsoft Web Browser Control (ActiveX Control) to Navigate to a specified URL representing a Graphic Image as follows:
Expand|Select|Wrap|Line Numbers
  1. Dim strURL As String
  2.  
  3. strURL = "http://www.commissaries.com/news/news_2007/images/fruit.jpg"
  4.  
  5. Me![ActiveXCtl8].Navigate strURL
worked like a charm! thanks ADezii!!!!
Jun 8 '08 #6

ADezii
Expert 5K+
P: 8,638
worked like a charm! thanks ADezii!!!!
You are quite welcome.
Jun 8 '08 #7

Post your reply

Sign in to post your reply or Sign up for a free account.