Report with Product Image

[mafhobb]

Hi all,

I've got a database that stores product information, product history as well as a product image. The image is embeded in the database.

I am creating a report to show product information and I want the product image to show up in the report. I have created a query that calls for the information, but when I add the image field to that query I get the error "Cannot group on Memo, OLE, or Hyperlink Object ([Project Main], [Item Image])", which is the image field?

What is happening? Is there any other way to do this. I need to use the embeded image.

Thanks

mafhobb

 

[scalextric59]

I would keep the images outside the database (in a folder, as .BMP or .JPG). That would reduce the DB size, and would improve speed. If you use the product code as the image name, then you can easily include it in the report on Detail_Format, and you would not have problems when grouping.

 

[boblarson]

Hi all,

I've got a database that stores product information, product history as well as a product image. The image is embeded in the database.

I am creating a report to show product information and I want the product image to show up in the report. I have created a query that calls for the information, but when I add the image field to that query I get the error "Cannot group on Memo, OLE, or Hyperlink Object ([Project Main], [Item Image])", which is the image field?

What is happening? Is there any other way to do this. I need to use the embeded image.

Thanks

mafhobb

Create your normal grouping query for your report WITHOUT the image field. Then, create a new query using that other query and then add the table in again and link the fields and include the image field from your table.

 

[mafhobb]

I see. Separate the OLE object to a separate query.

I just did this and it works!

Thank you Boblarson. You have helped me several times and your answers are always right on!

Maybe some day I can help you with something (other than Access)

Have a great new year!

mafhobb

 

[boblarson]

Glad it worked for you. Happy New Year!

 

[sysop470]

Thanks a lo....