Best way to show Report Images

[JDJohnson]

Simple question, I hope...

I have a database that is > 350 megs because I had to embed ".bmp"s into a photo table to get them to behave in a report (which needed to print the images along with the record in the report). I tried everything imaginable to call up the photo using VB in the report code but no luck.

Any ideas!

Jim, AL

 

[ghubbell]

Hi Jim,
I wonder if the image in your report is bound to your table properly? There's no reason you can't create a query connecting one table to its respective image(s) in another, and base your report off of this query. I.E.

Customer table~CustomerNumber (The report record) gets image #350 and #351 because in your image table you have a relationship Customer table CustomerNumber to CustomerNumber in the image table.

I believe your report needs an OLE Bound object frame to do this and if so, if it just isn't showing, are your screen and/or printer up to the job? Just ideas...
Gord
ghubbell@total.net