Solved

How to import pictures into a report in Excel.

Posted on 2008-06-17
11
1,507 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
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 21816110
mikejcurtis,

"Figured it out" how?

JeffCoachman
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

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

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

760 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now