Best way to display a chart on MS Access 97 form

[PRAV]

Hi, i need to display a chart on my ms access 97 home form so that
everytime you one the access application it displays an updated chart
about number of projects complete, late and very late. I have created
a query for each of them to return a count.Then i built a table
(tbl_project_info) so that complete, late and very late fields do a
lookup to their queries. Then create a chart according
tbl_project_info. I would like to know if there is the better way and
will it update the chart everytime you open the access application.

 

[PRAV]

Hi, i need to display a chart on my ms access 97 home form so that
everytime you one the access application it displays an updated chart
about number of projects complete, late and very late. I have created
a query for each of them to return a count.Then i built a table
(tbl_project_info) so that complete, late and very late fields do a
lookup to their queries. Then create a chart according
tbl_project_info. I would like to know if there is the better way and
will it update the chart everytime you open the access application.

 

[Rick Brandt]

Hi, i need to display a chart on my ms access 97 home form so that
everytime you one the access application it displays an updated chart
about number of projects complete, late and very late. I have created
a query for each of them to return a count.Then i built a table
(tbl_project_info) so that complete, late and very late fields do a
lookup to their queries. Then create a chart according
tbl_project_info. I would like to know if there is the better way and
will it update the chart everytime you open the access application.

Charts are like forms, reports and queries. Their data is derived from SQL
Statements that are re-run whenever the object is viewed. Charts in Access have
a bug in that they do not always refresh when displayed, but other than that
they do auto-update.

 

[Guest]

Rick,
This refresh bug is what I'm going through right now. But I'm using Access
2002. Has there been any improvements on how to refresh a chart in an Access
form (programmatically)?

I'm currently on a project where we have a few forms with charts and it's
always the refresh issue coming up all the time.

Ray

 

[Rick Brandt]

Rick,
This refresh bug is what I'm going through right now. But I'm using
Access 2002. Has there been any improvements on how to refresh a
chart in an Access form (programmatically)?

I'm currently on a project where we have a few forms with charts and
it's always the refresh issue coming up all the time.

Microsoft has a knowledge base article that describes a method to force a
refresh of the chart. I found that it "helps", but does not eliminate the
issue.