Hello everyone. I have an Access frontend linked to an MS SQL backend. An employees table has a field for each employee's photo (EmpPic). The data type (per Microsoft's advisory) is varbinary (MAX).
I am trying to use to PictureData property to set the value of a blank image box (Image81) to the content of the photo field. I can do it by VBA by typing:
Me.Image81.PictureData = Me.EmpPic.Value
However, I am trying to accomplish the same thing by a macro by using the SetValue action by typing
When the macro runs, I get the error:
Access failed to evaluate one or more expressions because 'PictureData' was referenced in an expression. Only functions and properties that are considered to be safe are allowed in expressions when Access runs in sandbox mode.
How do I fix this? I would really love to do it via a macro. The entire Access frontend uses macros and no VBA. Thanks.