If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
modify data source of an oleunbound (excel chart) in access report
Hi
I have included in my access report a chart created in excel I need to update the source data of this char on the On Open Event of the Report OLEUnbound39.Sheets(1).Range("B1")Value=.... brings the error " Object does not support this property" Yet, this error appears only if I use this code on thr On Open Event of the Report, whereas if refer to the report and its oleunbound object from a form for example the code works alright Any suggestions? |
Thread Tools | |
Display Modes | |
|
|