ole link to jpg

[Tom Kimberly]

I want to see jpg photos in my reports. OLE works ok for bmp files only.
Seems like 98% of all photos are jpgs, so this method is archaic.
Any solutions out there?

 

[Gina Whipp]

Tom,

Have a look at these... http://www.granite.ab.ca/access/imagehandling.htm

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Sylvain Lafontaine]

I never used it personally but DBPix from Ammara might be your ticket. It's
not free but there is a trial available for download, so you'll lose nothing
to give it a try.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)

 

[Suenaga]

I want to see jpg photos in my reports. OLE works ok for bmp files only.
Seems like 98% of all photos are jpgs, so this method is archaic.
Any solutions out there?

 

[Frank H]

You didn't mention what version of Access you're using.
You mentioned OLE, which implies that you are storing your pictures INSIDE
the database as data in a field. Do Not Do That.
Refer to the pictures via a hyperlink datatype in your table.
Use an image control on the report.
You may need to do some VBA on the report to make it work, depending upon
what version of Access you are using.

 

[Frank H]

Oops, mental lapse...been a while since I've done this.
If you use a hyperlink datatype, you will definitely need vba to extract the
filename path from the text stored in the hyperlink field.
Instead, use a text field, and enter the filename path. If I recall
correctly, an image control can then be bound to that text field in your
table. If not, try a bound object control.
Good luck; you'll get it to work.