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 Rhinorhino 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
Joined
Oct 20, 2006
Messages
44
Location
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