pivot chart

[GoalieGW]

Does anyone know how to create a Pivot Chart at run-time? I have a
database of meter readings that currently requires me to have 200 forms
created so the user can enter date criteria and have a chart pop up. I
would like to remove the forms and have them created at run-time. Any
ideas?

[Ed Robichaud]

I may misunderstand your question, but having 200! forms in even the most
complex database is surely too much. Why can't you have just a few data
entry forms that add/edit thousands of records. What is the table structure
and purpose of this database? The only forms that could be "created at
run-time" would be some sort of auto-form or template based one. Again, you
don't need a different form for each record, but a few well designed forms
(perhaps modified by OpenArg code, etc. for various circumstances). A pivot
chart is usually based on a query recordset of many records, so that the
chart shows some kind of meaningful relationship(s). What is it that you're
wanting to do?
-Ed
"GoalieGW" <Go******@ptd.net> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

Does anyone know how to create a Pivot Chart at run-time? I have a
database of meter readings that currently requires me to have 200 forms
created so the user can enter date criteria and have a chart pop up. I
would like to remove the forms and have them created at run-time. Any
ideas?

[GoalieGW]

Ed,
Each form is a pivot chart. The only way to create them is as a
form. The database keeps track of meter readings. The pivot charts
get their information from queries that show daily usage. What I would
like to do is not have so many charts pre-created. It is taking up way
too much space. I would like to be able to enter date criteria and
have a code to create the pivot charts based on the entered criteria.
As it stands now, the user enters the date range and clicks a button
that runs a code to open the corresponding pivot chart with the filter
set for the entered date range. I would like to automate this.

[Ed Robichaud]

Consider using your query recordsource for most/all of the filtering and
sorting of your records. One common approach is to have a "filter by form"
setup, let the user enter the desired criteria, pass those unbound control
values to the criteria(s) of your query, then use the query results as the
recordsource for your pivot chart. What you'd have then would be just one
pivot chart, but an infinite number of record sources for it.
-Ed
"GoalieGW" <Go******@ptd.net> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

Ed,
Each form is a pivot chart. The only way to create them is as a
form. The database keeps track of meter readings. The pivot charts
get their information from queries that show daily usage. What I would
like to do is not have so many charts pre-created. It is taking up way
too much space. I would like to be able to enter date criteria and
have a code to create the pivot charts based on the entered criteria.
As it stands now, the user enters the date range and clicks a button
that runs a code to open the corresponding pivot chart with the filter
set for the entered date range. I would like to automate this.