MS Chart in Access form with dynamic SQL as data source?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

butbi@mailinator.com - 07 Aug 2005 18:44 GMT

I'm using now At Your Survey by Duane to make a survey. I want to
create a form with some list boxes to choose, one list for the
indicators and one for the respondents. The indicator will be the
SELECT parameter and respondent the WHERE parameter.
What should I do so if I click the submit button a new or a subform
will be open with the chart which the data source comes from this
dynamic SQL?

I try to follow the hints by StevenT to create a MS Chart for Access
form but don't know how to write the SQL statement, how to bind it to
the data source row for tha chart an how to write the OnClick event
for the initial form.

Thank you for any help. I need it urgently.

Reply to this Message

Duane Hookom - 07 Aug 2005 20:01 GMT

I'm not quite sure I know what you want to do. I do have a query by form
applet that allows users to select fields, set criteria, group by,... The
results fo the designed query can be easily sent to print, html, csv, Word
Merge, Excel, form letter, or a graph/chart.

Signature

Duane Hookom
MS Access MVP

> I'm using now At Your Survey by Duane to make a survey. I want to
> create a form with some list boxes to choose, one list for the
[quoted text clipped - 10 lines]
>
> Thank you for any help. I need it urgently.

Reply to this Message

butbi@mailinator.com - 08 Aug 2005 11:10 GMT

Thank you for your reply.

I use your database AYS to input the raw data. Then I create some
queries to calculate several indicators. The query has following
structure:
respondent | country | indicator1 | indicator2.....| indicator n

In want to create charts by form with data source from a query like
that:
select [indicator x] from qryIndicators where [country]=countryX

(where indicatorX and countryX should be passed by form)

Can you give me some examples or hints (step by step, sorry I'm newbie).

Reply to this Message

butbi@mailinator.com - 08 Aug 2005 17:26 GMT

Shoud I write code for an onClick event for the command button with
following steps:

- create/run SQL : SELECT [indicatorX] from qryIndicators WHERE
[country]=countryX
- create a chart with data source from this SQL
- create a form with above chart

If it the right procedure I have to do, can you give me some hints how
to realize these steps in VBA.

Thank you.

Reply to this Message

Duane Hookom - 09 Aug 2005 05:36 GMT

Sorry, some how I didn't provide the link to the site with my query by form
that creates the graphs etc.
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

Signature

Duane Hookom
MS Access MVP

> Shoud I write code for an onClick event for the command button with
> following steps:
[quoted text clipped - 8 lines]
>
> Thank you.

Reply to this Message

butbi@mailinator.com - 09 Aug 2005 07:56 GMT

Thank you, I will try to modify your applet and let you know later.

Reply to this Message