SourceDoc does not work for reports - workaround?

[hunterw]

I have an external excel chart stored for every record.

In a form this works great, I just use the following code:

'        excelpath = "\\ccri-srv01\M2600\Labs\Keller\Images\" & [Mouse UID] & "\TumorSize.xls"
'
'        If Dir(excelpath) = "" Then
'            Me.TumorChart.SourceDoc = "\\ccri-srv01\M2600\Labs\Keller\Necropsy Manager\Blank.xls"
'            Me.TumorChart.Action = acOLECreateLink
'        Else
'            Me.TumorChart.SourceDoc = excelpath
'            Me.TumorChart.Action = acOLECreateLink
'        End If

Which, naturally, does not work for a report.

Bloat is not an option - I can't afford to embed these. I've googled a bit, and it seems the only course of action is to make a temporary table or hidden form, linking the .xls there. Can someone please let me know how to do this workaround?

 

[Pat Hartman]

Access uses the same charging engine as Excel (prior to A2007 when they deviate). Can you create the chart in Access?

 

[hunterw]

Doubtful I would use this solution...

My master table already has 255 columns, so I can't add any there. I would have to somehow generate a second table for every record, and then convert a large amount of back data to that new format.

Here's a solution suggested by google:

an alternative is to use an Unbound OLE Frame control on a hidden
form.
Update the OLE control on the form during the format event of the Detail
section, then copy the VALUE prop of the Frame control on the Form to that
of the report. This method does not always work but depends on the OLE Server app.
The core issue is that many OLE Server apps do not update the contents of
the Frame control properly under the Access report writer's OLE Host
interface. That's why so many control's will work on an Access form but
fail
on a report, or work with a Bound OLE Frame control but not an Unbound
one.

but what is the VALUE prop?

 

[Pat Hartman]

prop in this case is the abbreviation for property. Other than that I can't help with the example.

 

[hunterw]

my solution to this is to simply not use the OLE garbage. i embedded a macro in the excel chart so that it renders a .jpg of itself, then i just displayed that. pitiful job microsoft.