Derrived attributes

[jarvjarv]

I have a tbble with attributes

'image_data','resolution','created','file_size'

At the moment i'm sotring the 'image_date' as an OLE object datatype. Is there anyway that i can get access to automatically populate the attributes 'resolution', 'created' and 'file_size'? or could this be done using a different datatype for the 'image_data' itself?

PLEASE help, it would be SOOO much appreciated.

Thanks

Jarv

 

[jarvjarv]

Does anyone even know if this is possible in Access?

Please answer someone?

 

[ghudson]

Searching the forum is a great way to discover and learn the answers to your Access programming questions. Check out the following functions...

FileDateTime()
FileLen()
FileAttr()

FileDateTime("FilePathName")

You should also check our the Scripting.FileSystemObject for it is a powerful tool when working with files and their properties.

Also, I trust that you are not storing the graphics as an OLE in your db for that will quickly bloat your db. You should be storing the "location" of the file.

This might come in handy with your application... Browse [Find a directory or file]

 

[jarvjarv]

Thank you

appreciate the help

Jarv