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?
>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?
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)
>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?
>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?
It uses a simple contact database as an example. I have a more developed version which allows for the choice of which images per main record are to be included in the report. I can send you a copy if you mail me at:
kenwsheridan<at>yahoo<dot>co<dot>uk
Ken Sheridan Stafford, England
Tom Kimberly wrote: >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?
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 Rockford, IL
"Tom Kimberly" wrote: > 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?
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. -- Frank H Rockford, IL
"Frank H" wrote: > 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 > Rockford, IL
> "Tom Kimberly" wrote:
> > 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?
|
