Re: Report Images
- From: "Ken Snell \(MVP\)" <kthsneisllis9@xxxxxxxxxxxxxxxxxx>
- Date: Tue, 2 Jan 2007 21:27:15 -0500
You can do what you seek this way:
Me.ImageControl.Picture=Replace(Me.txtImageName.Value, "#", "", 1, -1,
vbTextCompare)
--
Ken Snell
<MS ACCESS MVP>
"NetworkTrade" <NetworkTrade@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D40CF7D1-58DC-4721-B269-46B7C5BCC68C@xxxxxxxxxxxxxxxx
Hi, searched this site and saw advice same as this string that to make an
image appear in a report to add code into the Report Detail OnFormat event
of:
Me.ImageControl.Picture=Me.txtImageName
and it wasn't working per my prior message - - - upon further
experimenting
I realized that this advice works fine if the txtImageName value is indeed
a
text field from the table i.e. C:\Test.jpg
but if txtImageName is a hyperlink defined table field, rather than a text
field, as is my case then it doesn't work.
just to experiment I threw in an additional unbound textbox in the report
and set its control to:
=txtImageName
to see maybe what the value from the hyperlink and when the hyperlink is
C:\Test.jpg active underlined blue hyperlink the unbound text box is
showing:
C:\Test.jpg#.../../../../
and this somewhat corresponds to the error message originally described
before 2220 that has lots of goobledygook in the path name
does one work with the hyperlink or does one somehow force the hyperlink
to
plain text.....would welcome advice.
--
NTC
"Ken Snell (MVP)" wrote:
Post more details about what you are doing, incluiding path names, etc.
--
Ken Snell
<MS ACCESS MVP>
"NetworkTrade" <NetworkTrade@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6D15A8F5-7330-47E1-9B50-FE10A2FDFAC3@xxxxxxxxxxxxxxxx
Hi - not sure if anyone will reply to this older dialog....just
searched
it
and it is my exact need at the moment. Followed your advice and am
getting
an error 2220 that "Access can not open" it lists the path name but
also
duplicate path name with %20 and other such goobledegook thrown in....
the hyperlink in the table opens fine to the jpg....so not clear as to
how
to correct this
for the sake of full disclosure; is a continuous report - and some of
the
fields are blank....wonder if this is the cause....
--
NTC
"Urban Planning Major" wrote:
"fredg" wrote:
On Tue, 31 Oct 2006 07:42:01 -0800, Urban Planning Major wrote:
Good day,
I have a table with picture links already entered in the table.
How
can I
convert these links to image that is seeable on a report with out
clicking?
My end result should be a report that haves an image next to my
reporting..
Do you mean you have the images stored in a folder on your hard
drive,
with the path to the image and it's name, i.e.
("C:\MyFolder\SunsetAtTheBeach.jpg")
stored in a field in your table?
Add an Image control to the report.
After you add and save the image control, delete it's picture
property.
Code the Detail Section Format event (if the picture is in the
detail
section):
Me!ImageName.Picture = Me![FieldName]
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
I'm sorry I am a novice at access. How do you add a image control?
Thanks
.
- Follow-Ups:
- Re: Report Images
- From: NetworkTrade
- Re: Report Images
- Prev by Date: Re: Report with duplicate information
- Next by Date: RE: Report Problems
- Previous by thread: Re: Report with duplicate information
- Next by thread: Re: Report Images
- Index(es):
Relevant Pages
|
|
