Inserting Images in report

[PicassoB]

Hi could some one please help - I have searched the forum for a solution but not found or understood anything I have seen to resolve my problem

I have a database for estimating accident damage on vehicles - the main form as fields for all the costings, plus a field that is hyperlinked to a folder for storing the vehicle images

when running the report I want to import the related images,
is there some code I can put in the query that opens the hyperlink and inserts the picture - please help as I am a total novice with the coding

 

[statsman]

You haven't memtioned which version of Access you are using.

Generally, in most of the pre Access 2007 versions, the generally accepted method would be to create an Ole object field in your table (or as many Ole fields as you require).

You would then link to the location where the photo is located. This is done by placing the cursor in the Ole field, right clicking and selecting "link" from the choices offered. This action should also start the wizard that will allow you to select the location of the photo(s).

For example: you are entering the details of a collision on your form. It comes time for the images. You right-click in the first image field, select link and the wizard will allow you to select the location of the image you wish. Repeat in the next image field for the next image you wish to add.

You can of course select to copy the image directly into the database. This is not suggested as images are quite large and will soon cause your database to run slowly. Linking is better.

I have only just started in Access 2007, so I haven't done any work with images yet.

If you just want the image in the report and not in your actual database, you would have to enter it as an independent object as you would any other graphic or image.

 

[PicassoB]

Thanks for the information will try this out - I have version 2003
I currently have the images stored in a different location with a hyperlink field in the estimate form, this works fine for the form but could not find away to bring them into the report, that is emailed to the customer
again many thanks for the responce

 

[Max D]

Access 2003 has poor imaging controls.

For good results, try AccessImagine component - it shows and prints high-quality pictures.

In fact, its the only way to print smooth 300 dpi images from Access.