Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

A little help with Photos imported into access via excel

Status
Not open for further replies.

NewYorkFashionToGo

Programmer
Oct 20, 2006
44
US
Hello, and thanks for looking at this post, I am trying very hard to make something execute in access. Basically I have excel xls sheet that I enter in my simple data and it spits out a finished html code for me......... I just started using access a few weeks ago and I am trying to import a photo into a form in access so I can see the product. I followed some documentation I found on Microsofts site pertaining to this type of application and my knowleged (so far) has not brought me upto speed on what I need to do to make this execute.

I found this page:
under where it says: Use an http:// path in a form

I created the module already that was pretty simple, I am stuck on two things. The first thing is: (It says)To use an http:// path in a form, use the Web browser control (shdocvw.dll) as follows: I dont know what I am supposed to do with the dll or where to find it: The second thing I am stuck on based on this information is the last part:
Add the following code behind the form: (Code Follows)
How do I add code Behind the form? I have made alot of ground in last few weeks using access, I am stuck here, There is nothing in the six books I have or websites I have searched to find anything further on this to make it execute. I really can use some advice!

Thanks in advance
Chris
 
To use an http:// path in a form
I don't think your product photo comes from the WEB, so you may ignore this part of the article !

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
I would prefer the photo did come off the web, I upload my photos via ftp to my own domain. So this is possible, I would prefer to do it this way rather than attaching. I get the link to work perfectlky fine however to get a physical image to show is another story.

From what I read it eventually may bog down access so I am leaning towards doing it via http:// . And I am very much interested in how I can get this to work with uploads and downloads.
 
Have you tried to play with the Application.FollowHyperlink method ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
No I haven't tried that, Because I did not know about it. I am rather new to access, I am better in excel. I am trying to gather up information on this currently to see what you are talking about exactly....
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top