Dynamically changing the graphs record source

#1

Hello everyone, I am trying to create a report that has a number of
graphs within it. But rather than place these graphs in the header or
footer I want to put them in the detail section and use VBA to give
them their recordsets. The only thing is that this does not seen to
be working, Access tells me that it is to late to change the row
source once I have started printing, has anyone got any advice on how
this may be acheived?

Many TIA

Nick

#2

Nick 'The Database Guy' wrote:

Quote:

Hello everyone, I am trying to create a report that has a number of
graphs within it. But rather than place these graphs in the header or
footer I want to put them in the detail section and use VBA to give
them their recordsets. The only thing is that this does not seen to
be working, Access tells me that it is to late to change the row
source once I have started printing, has anyone got any advice on how
this may be acheived?

Many TIA

Nick

Can you set the recordsource in the OnOpen event?

#3

On Jan 23, 3:08*pm, Salad <o... (AT) vinegar (DOT) com> wrote:

Quote:

Nick 'The Database Guy' wrote:

Hello everyone, I am trying to create a report that has a number of
graphs within it. *But rather than place these graphs in the header or
footer I want to put them in the detail section and use VBA to give
them their recordsets. *The only thing is that this does not seen to
be working, Access tells me that it is to late to change the row
source once I have started printing, has anyone got any advice on how
this may be acheived?

Many TIA

Nick

Can you set the recordsource in the OnOpen event?

No, well I could if it was an individual chart/graph but I want to
print lots of them on the same report.

#4

Nick 'The Database Guy' wrote:

Quote:

On Jan 23, 3:08 pm, Salad <o... (AT) vinegar (DOT) com> wrote:

Nick 'The Database Guy' wrote:

Hello everyone, I am trying to create a report that has a number of
graphs within it. But rather than place these graphs in the header or
footer I want to put them in the detail section and use VBA to give
them their recordsets. The only thing is that this does not seen to
be working, Access tells me that it is to late to change the row
source once I have started printing, has anyone got any advice on how
this may be acheived?

Many TIA

Nick

Can you set the recordsource in the OnOpen event?

No, well I could if it was an individual chart/graph but I want to
print lots of them on the same report.

I wish I could help but I can't. Are you attempting to change in the
OnFormat or OnPrint event? I don't see how a recordsource could be
changed. Could the graphs use calculated data? Ex:
Selet LastName, ReturnID(FirstName,MId, LastName) As IDVar From ...
and it would call a function called ReturnID() with parameters you pass?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Dynamically changing the graphs record source

comp.databases.ms-access comp.databases.ms-access

Dynamically changing the graphs record source - 01-23-2009 , 05:25 AM

Re: Dynamically changing the graphs record source - 01-23-2009 , 09:08 AM

Re: Dynamically changing the graphs record source - 01-26-2009 , 03:51 PM

Re: Dynamically changing the graphs record source - 01-26-2009 , 05:18 PM