Hi Everyone,
I need to make it so that a user can input photos into a OLE object field on one of my forms but i want to make sure they do not put too large of a file in it. is there a way to block files that i deem are to large (example anything larger then 1MB) in the access form that will stop the user from adding the file to the OLE object?
on a side note, I do know it is a lot better to link the photos in a folder on your desktop and pull the link into access that way. This approach is not conducive of what i'm trying to accomplish. I only state this because I'm looking for ways to solve this issue and not a way around it.
I need to make it so that a user can input photos into a OLE object field on one of my forms but i want to make sure they do not put too large of a file in it. is there a way to block files that i deem are to large (example anything larger then 1MB) in the access form that will stop the user from adding the file to the OLE object?
on a side note, I do know it is a lot better to link the photos in a folder on your desktop and pull the link into access that way. This approach is not conducive of what i'm trying to accomplish. I only state this because I'm looking for ways to solve this issue and not a way around it.