asked on

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.

jmoss111

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

ASKER CERTIFIED SOLUTION

Jeffrey Coachman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mikejcurtis

ASKER

I think I was too vague in my question. After further experimentation I figured it out.

Jeffrey Coachman

mikejcurtis,

"Figured it out" how?

JeffCoachman

mikejcurtis

ASKER

Combining Jeff's answer with this;
http://www.databasedev.co.uk/bound_image_report.html
I got what I needed. Thanks Jeff.

Jeffrey Coachman

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

mikejcurtis

ASKER

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

Jeffrey Coachman

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

mikejcurtis

ASKER

I'm good with that Gents!