Solved

How to import pictures into a report in Excel.

Posted on 2008-06-17
11
1,513 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
  • 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 250 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
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Record with #Error 8 34
Dinamic report to Crosstab query 9 35
XML Node Counting in MS Access VBA 4 37
Access 2016 - combo box 3 20
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

821 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