opens the report. I get the same error that I cannot perform the
action. Is there a way to completely load the image in the form
(hidden) then pass it to the report that way?
--- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote:
>
> Chad-
>
> You can do that in a Form, but I don't think you can do that in a
Report.
>
> John Viescas, author
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> Running Microsoft Access 2000
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
> For the inside scoop on Access 2007, see:
> http://blogs.msdn.com/access/
>
>
> -----Original Message-----
> From: [email protected] [mailto:[EMAIL PROTECTED]
On Behalf
> Of chadcbc
> Sent: Thursday, May 25, 2006 6:58 PM
> To: [email protected]
> Subject: [ms_access] renew object in bound frame
>
> I have a bound frame that I would like to display a different
excel
> chart for each different product. I can change the source
document,
> but when I try to create the link I get runtime 2793 - cant
perform
> the specified operation in the action property of the VB
procedure.
> I get the same error with acOLEUpdate. I have also tried to
requery,
> it doesnt break the code, but doesnt refresh the box either. Ive
> spent hours on this and cant figure it out. Any help would be
great.
>
> Private Sub RenewFluxLinChart()
> FluxLinChart.Class = "Excel.Sheet"
> FluxLinChart.OLETypeAllowed = acOLELinked
> FluxLinChart.SourceDoc = "E:\Links\Int\" & [Forms]![Datasheet]!
> [Serial Number] & "\FluxLin.xls"
> Reports![FinalTestDatasheetInt].FluxLinChart.Action = ""> acOLECreateLink
> End Sub
>
>
>
> Thanks,
> ~Chad
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
SPONSORED LINKS
| Microsoft access database | Database development software | Database management software |
| Database software | Inventory database software | Membership database software |
YAHOO! GROUPS LINKS
- Visit your group "ms_access" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
