RE: Rowsource of unbound object

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I'm not sure I understand your response.

Does this mean you tried the Report_Load and Detail_Format events?

I didn't say anthing about the Report_Activiate or Report_Page events.

--

Dale

email address is invalid
Please reply to newsgroup only.



"NevilleT" wrote:

Hi Dale

Same error using on activate.
If I use the page event I get a message "You can't set the row source
property in print preview or after printing has started."

Same error if I use the on format

"Dale Fye" wrote:

have you tried using the reports Load event?

Another place to try this would be in the reports Detail sections Format
event (assuming that chart object is in the detail section).

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.



"NevilleT" wrote:

This should be very simple but a few hours later ... well you know how it is.

I have a form which has a Gantt chart. I want to produce a printed version
so created a report. The Gantt chart can be sorted by sequence number, start
or finish date. You select the sort order using an option group on the form.

What I want to do is to change the report rowsource when the report opens to
use one of three query sorted in one of three ways - sequence, start or end.
I can do it manually and it works. I enter a different query as the
rowsource of the unbound object and it displays just as it should. When I
try to do it using code it fails telling me
"You entered an expression that has an invalid reference to the property
rowsource."

The code is:

Private Sub Report_Open(Cancel As Integer)
Select Case Forms!frmGanttChart.opgSortBy
Case Is = 1
Me.oleGraph.RowSource = "qryGanttGraphSeqOrder"
Case Is = 2
Me.oleGraph.RowSource = "qryGanttGraphStartOrder"
Case Is = 3
Me.oleGraph.RowSource = "qryGanttGraphFinishOrder"
End Select
End Sub

.

Relevant Pages

  • RE: Rowsource of unbound object
    ... I have a form which has a Gantt chart. ... What I want to do is to change the report rowsource when the report opens to ... use one of three query sorted in one of three ways - sequence, ...
    (microsoft.public.access.modulesdaovba)
  • Rowsource of unbound object
    ... I have a form which has a Gantt chart. ... What I want to do is to change the report rowsource when the report opens to ... use one of three query sorted in one of three ways - sequence, ...
    (microsoft.public.access.modulesdaovba)
  • RE: Rowsource of unbound object
    ... The report events are Open, Close, Activate, Deactivate, No Data, Page, ... I have a form which has a Gantt chart. ... What I want to do is to change the report rowsource when the report opens to ...
    (microsoft.public.access.modulesdaovba)
  • Re: Rowsource of unbound object
    ... That is because the Format function returns a string. ... This works in a query, not sure how it will work for your Gantt Chart ... The report events are Open, Close, Activate, Deactivate, No Data, ...
    (microsoft.public.access.modulesdaovba)
  • Re: RunSQL - MakeTable Query
    ... I have a form that opens on top of the report that once the user changes the ... depending on what the user picks as criteria for the chart. ... static RowSource, but the data underlying the RowSource needed to change ... In the SQL statement, I rename the fields from the original table ...
    (microsoft.public.access.formscoding)