How do I add photos to an Access report?

Use the Format or Print event of the relevant section.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Jeff" a_m.com wrote
in message ...
Hi Duane,

I've tried that too - the problem seems to be the there is no "On
Current"
event in reports - only on forms. FYI, I'm using Access 2003. Any
other
ideas?

Thanks for your help.

Jeff


"Duane Hookom" wrote in message
...
You need to set the Picture property in the On Current event of the
form.
There are some examples at
http://members.tripod.com/accdevel/imaging.htm.

--
Duane Hookom
MS Access MVP
--

"Jeff" a_m.com
wrote in
message ...
Hi,

I tried that - it doesn't work (it will only display a static
picture for
all records). Any other ideas?

Thanks!



wrote in message
...
have you tried useing the image control in the tool box.
Set the image controls picture property to the file path
of the desired pic.

-----Original Message-----
I'm about to go NUTS! All I want to do is to add photos,
that are listed by
their direectory path as a text file (for example,
c:/database/images/image1.jpg) in a query.

NOTHING I try will add them. I've looked in every Access
book I own and
everyone has a different "solution" - none of which
work.

While I'm finally starting to be able to "do things"
with Access (been
working with it for more than a year now), linked images
are completely
beyond me.

Thanks!
.

Hi Julie,

Well...almost! Just the same, I tried your suggestion - everything seemed to
go okay except that all I can get to display in the report is the file name
of the photo (a .jpg file) but no image. I even tried creating a
mini-database (two pictures) using your instructions - same thing.

Any other suggestions?

Thanks!

Jeff


"JulieD" wrote in message
...
Do let us know how you get on ....

"Jeff" m wrote in message
...
Thanks, Julie!

I haven't tried it yet (got to take my kids to get something to eat
before they starve) - but I'll give it a try as soon as I get back.

Again, thanks!

Jeff


"JulieD" wrote in message
...
Hi jeff

using "link" when you click on insert / object / create from file -
doesn't embed them .. it retains a link to them, so it should work for
what you want.

Cheers
JulieD

"Jeff" m wrote in
message ...
Hi Julie,

The photos are stored externally (it's the first real attempt I've made
at using photos but have always heard that it's best to store them
outside of the database to prevent bloat).

Just the same, the number of photos required for the database will
never exceed several hundred. As a result, I could probably embed them
in the database too. I'll try your suggestion too.
Thanks!

Jeff



"JulieD" wrote in message
...
Hi Jeff

in the table where the photos are stored what is the data type?

following is how i get reports with photos:
1) create table, put OLE Object as the data type for the photos
2) create a form, use insert / object / browse ... find picture click
linked - ok
3) create query based on the table(s) drawing out the fields i want to
see in the report
4) use the report wizard (create report using wizard) based on this
query
5) make report look pretty

never failed yet. Does it work for you if you do the above?

Cheers
JulieD

"Jeff" a_m.com
wrote in message ...
Hi,

I tried that - it doesn't work (it will only display a static picture
for all records). Any other ideas?

Thanks!



wrote in message
...
have you tried useing the image control in the tool box.
Set the image controls picture property to the file path
of the desired pic.

-----Original Message-----
I'm about to go NUTS! All I want to do is to add photos,
that are listed by
their direectory path as a text file (for example,
c:/database/images/image1.jpg) in a query.

NOTHING I try will add them. I've looked in every Access
book I own and
everyone has a different "solution" - none of which
work.

While I'm finally starting to be able to "do things"
with Access (been
working with it for more than a year now), linked images
are completely
beyond me.

Thanks!
.

Hi Julie and everyone else!

I just discovered something - as you know, I've been trying for quite some
time to add photos to my DB. I've tried all of your suggestions -

I had some success with the links on Duane's page that he recommended - my
existing DB looks most like the example on the demo there (at least my
directory path is stored in the same way like those under "Images As
External Files" - no matter what I try, though, I still can't get my images
to display in a report (although I can get them to work in forms).

Thanks Stephen for your suggestion too - haven't had much luck with it yet -
I'll keep trying.

Now for the "big winner" - Julie! I FINALLY got your suggestion to work but,
here's what I found out. The problem seems to be that, no matter what I try,
Access won't display my photos as they're .jpg files (funny thing is, they
do show up using Duane's example). I decided to experiment and converted a
couple of photos to .bmp files - lo and behold, .bmp files DO appear in
reports and work exactly as Julie mentioned.

Now the big question is, do I need to convert all of my .jpg to .bmp files?
(Ugh! I hope not - bmp files are not only bigger but it will take quite a
bit of time to convert them to .bmp).

Any ideas? Thanks!

Jeff






"Clueless" wrote in message
...
I'm about to go NUTS! All I want to do is to add photos, that are listed
by
their direectory path as a text file (for example,
c:/database/images/image1.jpg) in a query.

NOTHING I try will add them. I've looked in every Access book I own and
everyone has a different "solution" - none of which work.

While I'm finally starting to be able to "do things" with Access (been
working with it for more than a year now), linked images are completely
beyond me.

Thanks!

Hi again everyone,



This time, I've figured out what the problem was - once again, Microslop was
to blame (Ugh! It would be nice if they made such information easy to find -
I even own several Access 2003 books published by MS and none of them
mention this either). Apparently, .jpg, gif, and other formats do NOT work
with Access 2003 unless you want to deal with many other issues (which are
also hard to find). I just found this information at:



"What to do when you see file names instead of images in your Access
database



http://office.microsoft.com/en-us/as...504111033.aspx



and



"What to do when you see "Package" instead of "Bitmap Image" in your
database tables



http://office.microsoft.com/en-us/as...513811033.aspx "



It appears that the best solution is to CHANGE THE FORMAT of my files from
..jpg to .bmp.



I'm posting this here so that, hopefully, others will also find it. Thanks
again to everyone for their help!



Jeff

Jeff please stop creating a new thread each time you post but rather
keep everything to one thread for this issue.

You're really making this issue difficult and it need not be.

1) Forget about using OLE Frame controls. Use the standard Image control
instead.

2) There is absolutely no need to convert your Images from JPG to BMP.

3) Follow the step by instructions for displaying images on a Report
he
http://support.microsoft.com/?id=148463


--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Jeff" m wrote in
message ...
Hi again everyone,



This time, I've figured out what the problem was - once again,
Microslop was
to blame (Ugh! It would be nice if they made such information easy to
find -
I even own several Access 2003 books published by MS and none of them
mention this either). Apparently, .jpg, gif, and other formats do NOT
work
with Access 2003 unless you want to deal with many other issues (which
are
also hard to find). I just found this information at:



"What to do when you see file names instead of images in your Access
database



http://office.microsoft.com/en-us/as...504111033.aspx



and



"What to do when you see "Package" instead of "Bitmap Image" in your
database tables



http://office.microsoft.com/en-us/as...513811033.aspx "



It appears that the best solution is to CHANGE THE FORMAT of my files
from
.jpg to .bmp.



I'm posting this here so that, hopefully, others will also find it.
Thanks
again to everyone for their help!



Jeff

Hi Stephen,

Sorry about the new "threads" but I thought the topic had changed enough to
warrant it (especially as several people were contributing to the discussion
and I was trying to keep their thoughts together). Anyway, the suggestion
you just provided worked like a charm. Thanks! The answer was so simple that
I wish I had come across it much, much sooner.

Thanks again as it was exactly what I needed.

Jeff



"Stephen Lebans"
wrote in message ...
Jeff please stop creating a new thread each time you post but rather
keep everything to one thread for this issue.

You're really making this issue difficult and it need not be.

1) Forget about using OLE Frame controls. Use the standard Image control
instead.

2) There is absolutely no need to convert your Images from JPG to BMP.

3) Follow the step by instructions for displaying images on a Report
he
http://support.microsoft.com/?id=148463


--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Jeff" m wrote in
message ...
Hi again everyone,



This time, I've figured out what the problem was - once again,
Microslop was
to blame (Ugh! It would be nice if they made such information easy to
find -
I even own several Access 2003 books published by MS and none of them
mention this either). Apparently, .jpg, gif, and other formats do NOT
work
with Access 2003 unless you want to deal with many other issues (which
are
also hard to find). I just found this information at:



"What to do when you see file names instead of images in your Access
database



http://office.microsoft.com/en-us/as...504111033.aspx



and



"What to do when you see "Package" instead of "Bitmap Image" in your
database tables



http://office.microsoft.com/en-us/as...513811033.aspx "



It appears that the best solution is to CHANGE THE FORMAT of my files
from
.jpg to .bmp.



I'm posting this here so that, hopefully, others will also find it.
Thanks
again to everyone for their help!



Jeff

Hi Jeff

weird, i have access 2002 & 2003 on my system and have no problems
displaying jpegs and i don't have the photo editor ... not sure why mine
works but i'm not complaining!

glad it's all sorted, i'll have to have a read of the link Stephen gave you
in case i come across a problem in the future with ver 2002 / 2003

Cheers
JulieD

"Jeff" m wrote in message
...
Hi Julie and everyone else!

I just discovered something - as you know, I've been trying for quite some
time to add photos to my DB. I've tried all of your suggestions -

I had some success with the links on Duane's page that he recommended - my
existing DB looks most like the example on the demo there (at least my
directory path is stored in the same way like those under "Images As
External Files" - no matter what I try, though, I still can't get my
images to display in a report (although I can get them to work in forms).

Thanks Stephen for your suggestion too - haven't had much luck with it
yet - I'll keep trying.

Now for the "big winner" - Julie! I FINALLY got your suggestion to work
but, here's what I found out. The problem seems to be that, no matter what
I try, Access won't display my photos as they're .jpg files (funny thing
is, they do show up using Duane's example). I decided to experiment and
converted a couple of photos to .bmp files - lo and behold, .bmp files DO
appear in reports and work exactly as Julie mentioned.

Now the big question is, do I need to convert all of my .jpg to .bmp
files? (Ugh! I hope not - bmp files are not only bigger but it will take
quite a bit of time to convert them to .bmp).

Any ideas? Thanks!

Jeff






"Clueless" wrote in message
...
I'm about to go NUTS! All I want to do is to add photos, that are listed
by
their direectory path as a text file (for example,
c:/database/images/image1.jpg) in a query.

NOTHING I try will add them. I've looked in every Access book I own and
everyone has a different "solution" - none of which work.

While I'm finally starting to be able to "do things" with Access (been
working with it for more than a year now), linked images are completely
beyond me.

Thanks!

Hi Julie,

Well, I spoke too soon with Stephen's suggestion - his suggestion works fine
when I create a report from a table but, after I posted my response,
discovered that it doesn't always work when creating a report from a query.
It's VERY odd. Also, I had a previous version of Access on my machine and
removed it - I'm beginning to wonder if that's the problem. In addition, I
still have the photo editor - perhaps I'll remove that too.

Still working on it.

Thanks,

Jeff



"JulieD" wrote in message
...
Hi Jeff

weird, i have access 2002 & 2003 on my system and have no problems
displaying jpegs and i don't have the photo editor ... not sure why mine
works but i'm not complaining!

glad it's all sorted, i'll have to have a read of the link Stephen gave
you in case i come across a problem in the future with ver 2002 / 2003

Cheers
JulieD

"Jeff" m wrote in message
...
Hi Julie and everyone else!

I just discovered something - as you know, I've been trying for quite
some time to add photos to my DB. I've tried all of your suggestions -

I had some success with the links on Duane's page that he recommended -
my existing DB looks most like the example on the demo there (at least my
directory path is stored in the same way like those under "Images As
External Files" - no matter what I try, though, I still can't get my
images to display in a report (although I can get them to work in forms).

Thanks Stephen for your suggestion too - haven't had much luck with it
yet - I'll keep trying.

Now for the "big winner" - Julie! I FINALLY got your suggestion to work
but, here's what I found out. The problem seems to be that, no matter
what I try, Access won't display my photos as they're .jpg files (funny
thing is, they do show up using Duane's example). I decided to experiment
and converted a couple of photos to .bmp files - lo and behold, .bmp
files DO appear in reports and work exactly as Julie mentioned.

Now the big question is, do I need to convert all of my .jpg to .bmp
files? (Ugh! I hope not - bmp files are not only bigger but it will take
quite a bit of time to convert them to .bmp).

Any ideas? Thanks!

Jeff






"Clueless" wrote in message
...
I'm about to go NUTS! All I want to do is to add photos, that are listed
by
their direectory path as a text file (for example,
c:/database/images/image1.jpg) in a query.

NOTHING I try will add them. I've looked in every Access book I own and
everyone has a different "solution" - none of which work.

While I'm finally starting to be able to "do things" with Access (been
working with it for more than a year now), linked images are completely
beyond me.

Thanks!

There is absolutely no difference between using a Table or Query as the
Recordsource.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Jeff" m wrote in
message ...
Hi Julie,

Well, I spoke too soon with Stephen's suggestion - his suggestion
works fine
when I create a report from a table but, after I posted my response,
discovered that it doesn't always work when creating a report from a
query.
It's VERY odd. Also, I had a previous version of Access on my machine
and
removed it - I'm beginning to wonder if that's the problem. In
addition, I
still have the photo editor - perhaps I'll remove that too.

Still working on it.

Thanks,

Jeff



"JulieD" wrote in message
...
Hi Jeff

weird, i have access 2002 & 2003 on my system and have no problems
displaying jpegs and i don't have the photo editor ... not sure why
mine
works but i'm not complaining!

glad it's all sorted, i'll have to have a read of the link Stephen
gave
you in case i come across a problem in the future with ver 2002 /
2003

Cheers
JulieD

"Jeff" m wrote in
message
...
Hi Julie and everyone else!

I just discovered something - as you know, I've been trying for
quite
some time to add photos to my DB. I've tried all of your
suggestions -

I had some success with the links on Duane's page that he
recommended -
my existing DB looks most like the example on the demo there (at
least my
directory path is stored in the same way like those under "Images
As
External Files" - no matter what I try, though, I still can't get
my
images to display in a report (although I can get them to work in
forms).

Thanks Stephen for your suggestion too - haven't had much luck with
it
yet - I'll keep trying.

Now for the "big winner" - Julie! I FINALLY got your suggestion to
work
but, here's what I found out. The problem seems to be that, no
matter
what I try, Access won't display my photos as they're .jpg files
(funny
thing is, they do show up using Duane's example). I decided to
experiment
and converted a couple of photos to .bmp files - lo and behold,
..bmp
files DO appear in reports and work exactly as Julie mentioned.

Now the big question is, do I need to convert all of my .jpg to
..bmp
files? (Ugh! I hope not - bmp files are not only bigger but it will
take
quite a bit of time to convert them to .bmp).

Any ideas? Thanks!

Jeff






"Clueless" wrote in message
...
I'm about to go NUTS! All I want to do is to add photos, that are
listed
by
their direectory path as a text file (for example,
c:/database/images/image1.jpg) in a query.

NOTHING I try will add them. I've looked in every Access book I
own and
everyone has a different "solution" - none of which work.

While I'm finally starting to be able to "do things" with Access
(been
working with it for more than a year now), linked images are
completely
beyond me.

Thanks!