Hi,

I have a training database, and my user would like to scan an image of staff qualifications, and click on them to view the scans from within the database. I'm not sure which field type my scanned file would be, Hyperlink? OLE? some other?

thanks

Bob

In A2003 you should keep the scanned images outside the database and just put the path to the file in a text field in the table.
In the click/doubleclick event of the textbox that displays the path just put the code...
Application.Followhyperlink me.textboxname

This will open the image in whatever application the fiel type has been associated with.

Check this link => tter Angel's MS Access Downloads
Look for 'Picture in a database'-example

Greetz from Belgium

Luc aka Kuifjexx

thank you gentlemen