Report picture from Hyperlink

[CJ]

Hi Groupies

I know this has been asked before but I can never seem to find an actual
answer.

I have an image selected in a record via a hyperlink. The field is called
hypMap the table is tblSite. I can not figure out how to get the file path
from the hyperlink, so I do not know how to get the image to load in my
report with the OnClick event of a button.

Ideally, I would like the report to open with the picture centered and a
particular size but I can't even get started.

Any ideas?

 

[Stockwell43]

Hi CJ,

This link shouls help you with adding the picture to your report.

http://office.microsoft.com/en-us/access/HA011472041033.aspx?pid=CL100570041033#DispImgWinOrForm

As far as the path of the hyperlink goes if it is stored in a table open the
table to view the hyperlink, pleace your cursor over the link and right
click, scroll down to hyperlink, when the menu opens select Edit Hyperlink,
once you selcet it a box should open look at the very bottom and you should
see the path of the hyperlink where is says Address:.

 

[CJ]

That's the most information I have ever seen on the subject.

Thanks very much for directing me down the right path.
--
Thanks for the brainwaves!

CJ
I blame the parents........

Hi CJ,

This link shouls help you with adding the picture to your report.

http://office.microsoft.com/en-us/access/HA011472041033.aspx?pid=CL100570041033#DispImgWinOrForm

As far as the path of the hyperlink goes if it is stored in a table open the
table to view the hyperlink, pleace your cursor over the link and right
click, scroll down to hyperlink, when the menu opens select Edit Hyperlink,
once you selcet it a box should open look at the very bottom and you should
see the path of the hyperlink where is says Address:.

 

[Stockwell43]

You're quite welcome CJ, glad I could help! )

That's the most information I have ever seen on the subject.

Thanks very much for directing me down the right path.