How do I add photos to an Access report?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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.
 
Hi,

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

Thanks!
 
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
 
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
 
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
 
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
 
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
 
Do let us know how you get on ....

Jeff said:
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
Click to expand...
 
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.
 
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
 
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
 
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/assistance/HA011504111033.aspx



and



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



http://office.microsoft.com/en-us/assistance/HA011513811033.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
here:
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.
 
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
 
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
 
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
 
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.
 
Back
Top