It's an Ole object. I'm trying to set a vba object to "content", rather than the field object. I've searched all over for the answer and can't seem to find a solution that doesn't require the object to be read from a control on a form.
I hoped that something like this would work:
Set...
Evening all,
I can't find the right way to reference an object embedded within a field.
Here's my code:
Dim RS As DAO.Recordset
Dim XL As Object
Set RS = CurrentDb.OpenRecordset("SELECT * FROM [Excel_Workbooks]", dbOpenDynaset, dbSeeChanges)
Set XL = RS![Workbook]
...
I can't see how to...
Hi all,
This is driving me mad... I've been searching the forum all morning, but can't find a solution.
I have an embedded (unbound object frame) Excel Chart (XY Scatter) and I'm trying to get it to update the displayed object after I have made changes to the underlying chart object. Here's my...