Pictures from form to reports

[krutoigoga]

Hi everyone.
Database tracking various issues. Using a form to enter the data, which is recorded in a table. Table has a Field data type as "Attachment", Form has the option to attach a pic which was created by dragging and dropping the attachment field from the field list (add existing fields in design view). Each entry needs a separate pic.
Issue is that report does not display these pics, instead it displays unrecognized text. I tried using OLE objects too (don't understand much about them) but that did not work either.
Can anyone help with pictures displaying on reports?

 

[AccessBlaster]

Hi everyone.
Database tracking various issues. Using a form to enter the data, which is recorded in a table. Table has a Field data type as "Attachment", Form has the option to attach a pic which was created by dragging and dropping the attachment field from the field list (add existing fields in design view). Each entry needs a separate pic.
Issue is that report does not display these pics, instead it displays unrecognized text. I tried using OLE objects too (don't understand much about them) but that did not work either.
Can anyone help with pictures displaying on reports?

Have you looked at the Catalog report in the Nothwind sample? scroll thru all the records and then look at it in design view.

 

[Simon_MT]

If you what referential images i.e. images contained outside the database, thr first thing you need to do is to be able to associate the image with the record. I tend to use a unique StockID so record 25678 will have an image 25657.jpg. This I have called ImageFile and each form or report will have a hidden control for ImageFile, often buried underneath the image.

The next issue to map out the directory, I have a function to do this and other functions to get the picture.

This is the preliminary steps and if this what you want I can supply you with the scripts all VBA and contained in Functions.

Simon

 

[krutoigoga]

Issue resolved. Had to drag and drop the "attachment" from field list into report .. just like the form.
Thanks guys