Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

How to import pictures into a report in Excel.

Posted on 2008-06-17
11
Medium Priority
?
1,523 Views
Last Modified: 2013-11-28
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
Comment
Question by:mikejcurtis
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
11 Comments
 
LVL 18

Expert Comment

by:jmoss111
ID: 21807592
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
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 1000 total points
ID: 21811465
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
 

Author Comment

by:mikejcurtis
ID: 21814705
I think I was too vague in my question. After further experimentation I figured it out.
0
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 21816110
mikejcurtis,

"Figured it out" how?

JeffCoachman
0
 

Author Closing Comment

by:mikejcurtis
ID: 31468102
Combining Jeff's answer with this;
http://www.databasedev.co.uk/bound_image_report.html
I got what I needed. Thanks Jeff.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 21822041
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
 

Author Comment

by:mikejcurtis
ID: 21822093
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
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 21822489
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
 

Author Comment

by:mikejcurtis
ID: 21836194
I'm good with that Gents!
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question