Report Images

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..

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

"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

On Tue, 31 Oct 2006 12:46:02 -0800, 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

In Report Design View, click on the ToolBox tool button (it's icon is
a hammer and wrench).
Make sure the Wizard button (The Wand with Stars) is NOT depressed.
Then select the Image control and drag it onto your report.
Delete it's attached label.

Then code the Section's Format event as mentioned in the previous
message.


--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

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

Post more details about what you are doing, incluiding path names, etc.

--

Ken Snell
MS ACCESS MVP

"NetworkTrade" wrote in message
...
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

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" wrote in message
...
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

You can do what you seek this way:

Me.ImageControl.Picture=Replace(Me.txtImageName.Va lue, "#", "", 1, -1,
vbTextCompare)

--

Ken Snell
MS ACCESS MVP


"NetworkTrade" wrote in message
news
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" wrote in message
...
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

thanks....I went down another path of exploring the hyperlink.

Discovered the HyperlinkPart function. Put that in a calculated field in a
query and am able to convert the hyperlink to text with just the part of the
hyperlink I need...i.e. the path.
--
NTC


"Ken Snell (MVP)" wrote:

You can do what you seek this way:

Me.ImageControl.Picture=Replace(Me.txtImageName.Va lue, "#", "", 1, -1,
vbTextCompare)

--

Ken Snell
MS ACCESS MVP


"NetworkTrade" wrote in message
news
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" wrote in message
...
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

I have the same question, but I have an image that's an OLE object that will
vary on the report based on user entry. Basically, it's the logo for the
letterhead of the report, that will vary with which program I use. But on
report preview view, I just seem the name of the file, ex: logo.gif, and not
the icon itself - any suggestions?


"NetworkTrade" wrote:

thanks....I went down another path of exploring the hyperlink.

Discovered the HyperlinkPart function. Put that in a calculated field in a
query and am able to convert the hyperlink to text with just the part of the
hyperlink I need...i.e. the path.
--
NTC


"Ken Snell (MVP)" wrote:

You can do what you seek this way:

Me.ImageControl.Picture=Replace(Me.txtImageName.Va lue, "#", "", 1, -1,
vbTextCompare)

--

Ken Snell
MS ACCESS MVP


"NetworkTrade" wrote in message
news
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" wrote in message
...
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