OLE Object in Report

  • Thread starter Thread starter Jinee
  • Start date Start date
J

Jinee

Hi all,

I am using Access 2002, and I have this report which
display a graph(OLE Object--unbound).
The rowsource of this OLE object should be based on a
query and with the conditions that based on the 2 values
in the text fields (txt1, txt2) in the form frmMain that
opens that report.

However, it seems i can't set the rowsource in the code.
(I tried to set the rowsource property of the OLE object
in the report onopen event)

How can i get around with this?

Any suggestions appreciated.

Jinee
 
Jinee

I am having the same problem, attempting to set the RowSource member of an 'OLE Unbound Graph', a procedure
which executes correctly if I step through the code, however when running as normal an error occurs as thus:

Run-time error'2455':

You entered an expression which has an invalid reference to the
property RowSource

Does anyone have any ideas on working around this problem or is there a way to generate an OLE Graph 'on the
fly' in Visual Basic? I have searched endlessly through the various posts and whilst I realise no-one is obliged to
help anyone in these posts, I amongst others would really appreciate the help

Thanks in advance,

Chops

----- Jinee wrote: -----

Hi all,

I am using Access 2002, and I have this report which
display a graph(OLE Object--unbound).
The rowsource of this OLE object should be based on a
query and with the conditions that based on the 2 values
in the text fields (txt1, txt2) in the form frmMain that
opens that report.

However, it seems i can't set the rowsource in the code.
(I tried to set the rowsource property of the OLE object
in the report onopen event)

How can i get around with this?

Any suggestions appreciated.

Jinee
 
Back
Top