Limit attachment size and filetype to jpg

[victorsales]

Hi All,

I have a field in my database (I'm using Access 2007) configured as Attachment under the DataType column on DesignView.
I was expecting to find an option to limit the attachment size (max 250Kb) and more importantly to limit the filetype you can actually upload. In my specific case only jpg should be attached.

Does anyone know how to do it?

Any help will be appreciated.
Thanks,
Victor

 

[pr2-eugin]

Hello victorsales, I am sure you can do it with VBA, but it will have a little bit more coding, and also it would have to be a Hyperlink more than an Attachment type.. I might be wrong..

 

[victorsales]

Hi pr2-eugin,

thank you for the insight. Would you be able to post a link with the VBA code or point me in the right direction?

Thanks,
Victor

 

[pr2-eugin]

For starters, you need to know the FileDialog.. Then you need to look in File/Directory functions available for VBA..

I know this is not a straight forward BOOM answer to your question, but you will be able to build the function based on the methods, post back if you find something hard to follow..