Search results

  1. S

    Reference an OLE object in a field / recordset.

    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...
  2. S

    Reference an OLE object in a field / recordset.

    Thanks... It's an embedded excel workbook.
  3. S

    Reference an OLE object in a field / recordset.

    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...
  4. S

    Embedded Excel Chart Object Not Updating

    Excellent. Thank you.
  5. S

    Embedded Excel Chart Object Not Updating

    Thank you. There are some interesting threads.
  6. S

    Embedded Excel Chart Object Not Updating

    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...
Top Bottom