Again: Command button for picture

[Montemontgo]

Sorry for being insistent. I just can't believe that it shoudn't be possible to have a command button in my form which opens a jpg picture stored in a separate folder. While it was easy to open a viewer like IrfanView I did not succeed in defining the name of the picture, which -of course- has to correspond with the field "name" in the data base. Please have a look at the screenshot. Is far as I understand Access can not handle jpg's and so I have to use a external viewer. Is this correct?

 

[trucktime]

Pictures

You may want to check this out, shows you how you can pull in a link to a local file and how to extract drive, path, filename and filesize

http://www.access-programmers.co.uk/forums/showthread.php?t=75790

Of course you can ad a command button and use this code to open the picture using the program that is associated with it:

Application.FollowHyperlink LinkField

Good Luck
Trucktime