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

interactive graph in an acess form

P: 4
I am currently working on creating a visual calculator in an access form. The visual bit being a graph and the interactive bit (or what I would like) being that by moving sliders on a series of sub forms in the main form, which I would like to auto select records as you scroll one way or another.

This would populate fields in the main form which linked by a query re-populates the graph via a setvalue macro, currently activated via the combo box on selection of an entry.

While this works with combo box manual selections, I am having difficuties in establishing a more user freindly sliders set up. Problem im having is getting the auto select bit to work in the sub forms based on usering the slider to scoll one way or the other.

The other annoying prob I have is with the refresh command. While I can manually refresh the graph I'd like the graph to update autoatically without having to press a command button. I have tried adding it as an event procedure on the fields that get updated by making a selection in the combo boxs (on which the query for the chart is based) in the sub forms but this doesnt work. Also tried a macro to do this but i cant get this to work either.

All help appreciated,

Kev
Apr 1 '07 #1
Share this Question
Share on Google+
1 Reply


ADezii
Expert 5K+
P: 8,610
I am currently working on creating a visual calculator in an access form. The visual bit being a graph and the interactive bit (or what I would like) being that by moving sliders on a series of sub forms in the main form, which I would like to auto select records as you scroll one way or another.

This would populate fields in the main form which linked by a query re-populates the graph via a setvalue macro, currently activated via the combo box on selection of an entry.

While this works with combo box manual selections, I am having difficuties in establishing a more user freindly sliders set up. Problem im having is getting the auto select bit to work in the sub forms based on usering the slider to scoll one way or the other.

The other annoying prob I have is with the refresh command. While I can manually refresh the graph I'd like the graph to update autoatically without having to press a command button. I have tried adding it as an event procedure on the fields that get updated by making a selection in the combo boxs (on which the query for the chart is based) in the sub forms but this doesnt work. Also tried a macro to do this but i cant get this to work either.

All help appreciated,

Kev
As far as your scrolling mechanism:
__1. Insert ==> ActiveX Control
__2. Microsoft Slider or Microsoft ProgressBar Controls
__3. Set Min value to 1 - Max value to the Record Count
__4. In the appropriate Event of the Control (Update/Change), synchronize its value to the Current Record.
__4. If you are using Navigation Buttons, set the Control's Value to the CurrentRecord value within the Form's Current Event.
Apr 6 '07 #2

Post your reply

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