Search results

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