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
1 4221 ADezii 8,834
Recognized Expert Expert
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.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Magnus Lie Hetland |
last post by:
Is there any interest in a (hypothetical) standard graph API (with
'graph' meaning a network, consisting of nodes and edges)? Yes, we
have the standard ways of implementing graphs through (e.g.) dicts
mapping nodes to neighbor-sets, but if one wants a graph that's
implemented in some other way, this may not be the most convenient (or
abstract) interface to emulate. It might be nice to have the kind of
polymorphic freedom that one has with,...
|
by: nivas.meda |
last post by:
Hi,
I have an excel sheet with a graph and cells.If i change the value in
the excel cells the graph will reflect.Now i am going to implement this
functionality in html page.I successfully saved this as interactive
html page.Now my requirement changes a bit.The excell cells will not
visible to others.i have a text box,If i change the value in text box
the excel template cell value need to change.
I did the follwing steps for creating...
|
by: nivas.meda |
last post by:
Hi,
I have an excel sheet with a graph and cells.If i change the value in
the excel cells the graph will reflect.Now i am going to implement this
functionality in html page.I successfully saved this as interactive
html page.Now my requirement changes a bit.The excell cells will not
visible to others.i have a text box,If i change the value in text box
the excel template cell value need to change.
I did the follwing steps for creating...
|
by: JD Kronicz |
last post by:
Hi .. I have an issue I have been beating my head against
the wall on for some time. I am trying to use late
binding for MS graph so that my end users don't have to
worry about having the right version of the MS Graph type
library. Up until now I have been walking them through
the process of setting the references to include their
version of MS Graph library.
My problem is that I can not seem to get the syntax
correct .. or perhaps...
|
by: Jeff |
last post by:
Hi
I have a report with a graph on it and want to change the minimum and
maximum values for the value axis when it is previewed. This can't be done
by adding code in the Open event as once the report has started printing the
properties can't be changed.
It can be done with an MDB by opening it in design mode hidden, making the
change, saving it and then opening it in preview mode. However, this
obviously doesn't work in an MDE which...
| |
by: MLH |
last post by:
A97
Am having difficulty displaying graph in Form View that I see fine
in graph control on form opened in design view. I know I'm doing
something wrong.
If I open the form in design view - I see the graph in the graph
control. If I dbl-clik the graph control, microsoft graph opens and
displays the graph fine there too.
|
by: eclypz |
last post by:
I have a webpage created in access, with an object graph (like a pivot
graph).
I don't know if it is possible to export that graph, i need to export
it, but don't know how to.
Can any one helpme?
Thanx,
|
by: mylog |
last post by:
I have downloaded a GLEE(Graph Layout Execution Engine) and written the following code to display a windows form from a web page but i am encountering with a small problem on displaying the graph into the display and I am getting the following error when I run the web page.Can anybody solve this problem. I would be very grateful. Thanks
Error:
System.InvalidOperationException: Showing a modal dialog box or form when the application is not...
|
by: sydneytroz |
last post by:
I am writing a program to simulate a double displacement reaction getting to equilibrium, but I am having some trouble graphing the particles' concentrations. It seems that it's only possible to pan and zoom the graph once the program exits (when running it from IDLE), but I don't want to have to kill the sim every time I want to view the graph (besides, when I do, the graph window dissappears).
The following code contains all the graphing...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |