Pics in Reports

[Rod Girringun]

I am updating our cultural heritage database which contains nearly 1100 points of interest. As part of this upgrade I adding photographs of our sites to the database - each site has an individual subdirectory which contains photos and other information. Photos are currently linked to the database via a hyperlink to a HTML page and the photos are viewed through this page.

I now wish to add 2 photos for each site to a pre-formatted site report. I want to avoid embedding the photos in the database because of the number of photos involved and their file sizes.

Is it possible to create a hyperlink (or other field) to the database which will allow a photo to be pulled into a report from a subdirectory. Currently my HTML pages work with dynamic links (..\).

Any thoughts...

 

[mnsmwk91]

I have a simple soloution...Try this:

create a form and from the tool box choose the "image" control to insert in your form. A dialogue box will open to select an image. Select an image from where you stored your images. If you notice, in the picture property the path of the image u selected is typed.

In the on current event of the form point to a differrent image i.e.:

Me.Image6.Picture = "C:\ZFP\Tools\Lab\joker.jpg"

where image6 is the name of the control. When you open the form u will see the new image.

What I want to say is that you can play with this path in the on current event by doing something like the following:

Me.Image6.Picture = "C:\ZFP\Tools\Lab\" & txtimagename & ".jpg"

where txtimagename is the name of the image that you want to show, which means that you can add a field that stores the image name for each record. or you can add a hyperlink field to your table that points to image and use it to show the image in the "image6" image control (if u use this you have to take out the "#" at the begining and end of the hyperlink path.

This is applicable if you want to show each record separate....