Derrived Attributes

[stort]

I've got a table called 'Images'
and in this table i want the details about images to be stored such as;

'location','size','resolution'

'location' i'm storing as a hyperlink to the image itself, and as for 'size' and 'resolution' i would like these to be automatically populated from the file itself? can this be done? if so how? can it be done if i use OLE object as the datatype instead of a hyperlink to the image? (p.s. i'm not a VBA programmer so if it requires this could you please be very specific)

Thank you very much

Stort

 

[Crowley16]

actually, I've just had to do this for something else completely and I've used vbs to do it, maybe you can adapt the code for vba, it shouldn't require any more than trivial changes...


function GetPictureAspect(path)
set pic = LoadPicture(path)
GetPictureAspect = pic.height/pic.width
end function

--------------------
Procrastinate Now!