By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,568 Members | 1,713 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,568 IT Pros & Developers. It's quick & easy.

Slider bar control for modification of data in a graph

rwbarrette
P: 1
Hi all,

I just joined 'the scripts' after a year of using it as a great resource, mostly for Python. However, I've been beating my head in for a while now trying to find a solution for a problem I'm having in Access 2003. I was hoping someone could help me out with this.

I'm trying to use two sliders to define the upper and lower range for data displayed on an unbound MS8 graph in my form. The form initially shows a graph of the entire data set, which has a query as the record source. I have two slider controls (microsoft slider control 6.0 (SP4))under the graph, one which defines the lower limit, and the other as the upper limit. When the sliders are adjusted, I want the graph to display ONLY the selected region, in real time. Once the relevent data is selected, it gets stored in a separate table.
The problem I'm having is that I've been trying to tie the value of the slider to the query, but it doesn't automatically refresh the chart data, and even when I set up a repaint or requery macro in the ON UPDATED property, I still can't get it to work. I'm guessing there is probably a better way to do this using the coding window. Any suggestions would be greatly appreciated. Thanks
Feb 28 '08 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 446
Hi

A fellow contributer (JaxJagFan) posted some code in this thread that gave an example of changing the scale in an MS Graph. It might be of some help.

I think that I see you are trying to scroll and zoom interactively in a MS chart. What a novel Idea ! I must try this when I get time.

S7
Mar 3 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.