Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1531
  • Last Modified:

How to import pictures into a report in Excel.

In Microsoft Access, I am trying to import pictures into a report or if necessary the access database automatically according to a file path generated in one of the forms.  Is there a simple control, linking method, or code I could use to import pictures using the file path from the form.  
0
mikejcurtis
Asked:
mikejcurtis
  • 4
  • 4
1 Solution
 
jmoss111Commented:
objSht.range("A1").select
            objSht.Rows("1:1").RowHeight = 51
            objSht.Columns("A:A").ColumnWidth = 17.57
            'objSht.Pictures.Insert(me!txtpath & "\myfile.jpg").select
0
 
Jeffrey CoachmanMIS LiasonCommented:
mikejcurtis,
Too Many questions:
-How many images are we dealing with?
-Is the from open when the report is being generated?
-Do you really want to *IMPORT* the images, or do you just ned to display them?
-Is the Form Bound?
-Is the Report Bound?

Please provide enough detail for us to provide a solution without needing extra info.

In any event,...
Here is a sample illustrating your request in it's purest form.

JeffCoachman
Access-EEQ23492799DisplayImageOn.mdb
0
 
mikejcurtisAuthor Commented:
I think I was too vague in my question. After further experimentation I figured it out.
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
Jeffrey CoachmanMIS LiasonCommented:
mikejcurtis,

"Figured it out" how?

JeffCoachman
0
 
mikejcurtisAuthor Commented:
Combining Jeff's answer with this;
http://www.databasedev.co.uk/bound_image_report.html
I got what I needed. Thanks Jeff.
0
 
Jeffrey CoachmanMIS LiasonCommented:
OK,

Thanks.
;-)

Please click the "Request Assistace" button and request that my post be "un-accepted" and your post be "Accepted" as the solution.

JeffCoachman
0
 
mikejcurtisAuthor Commented:
Well, I thought since your answer gave me the clues I needed to get the complete answer, I should give the points to you. Not so?
Mike
0
 
Jeffrey CoachmanMIS LiasonCommented:
mikejcurtis,

You only need select the post that actually solved your issue.

I believe you can even request that the points be split between your post and mine.
(If you insist)
;-)

When you click the "Request Attention" button, make this inquiry

JeffCoachman
0
 
mikejcurtisAuthor Commented:
I'm good with that Gents!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now