473,659 Members | 2,987 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

What VBA code displays data point details when you click on the point in a chart?

2 New Member
I have created an SPC chart in Access. I need specific details of each data point wihtin the line graph to display when you hover over or double-click on the specific data point. It should include the data point value and which test was failed if out of spec. The data resides in a table. I am looking for the VBA code that will perform this task.
Thanks.
Dec 20 '10 #1
2 3020
Stewart Ross
2,545 Recognized Expert Moderator Specialist
I'm not aware of any event you could use which would allow you to retrieve datapoint values on mouseover. Access has an On MouseMove event, but I doubt that it will be useful to you without using Windows API functions to determine exactly what datapoint the mouse is hovering over.

Perhaps other contibutors know better than I, but my immediate reaction is to say that Access itself cannot do what you ask as there are no datapoint mouseover events which you can tap into.

-Stewart
Dec 20 '10 #2
tmarynell
2 New Member
Stewart,
I tried using the MouseMove event, but as you indicated I could not display the data for a specific data point. I'm still hoping for a solution.
Thanks for your help,
Tianna
Dec 20 '10 #3

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

Similar topics

9
3588
by: msnews.microsoft.com | last post by:
Hello! I'm Jim by asp How can show "abc" in textbox when click one botton?
0
1360
by: yoganand reddy | last post by:
Hello, we are developing component in c# like a datagrid , if u are selecting any cell in grid it selects the total row and display record there itself , if any body have this idea please share to me... Yogi *** Sent via Devdex http://www.devdex.com ***
8
2004
by: Steve Jorgensen | last post by:
Hi folks, I'm posting this message because it's an issue I come up against relatively often, but I can't find any writings on the subject, and I haven't been able to figure out even what key words one would use to look for it. First, in broad philosophical terms, code actually -is- data. Code is the data that's fed into a compiler, interpreter, or microprocessor that tells it what to do. Code execution is, then, just a form another...
2
1108
by: **Developer** | last post by:
I've been asking about a Menu problem I have without results. So here is a test case I've developed that shows the problem. Simply create a soultion with one project containg one form and replace the form code with this. Run it, right click and select Edit/Paste Special/Test1 Then try to do that again
1
1862
by: robin1983 | last post by:
Hi to all, i m newer to this site and fresher in Ajax world. Actually i get a problem while accessing data from Database. I have a combo box in my pages. Actually i want to access data from the database and put in a form variable as soon as when i select the name in the combo box. For more details i m giving the code below.. this is my first pages: empAttedence.php <table width="100%" cellpadding="2" cellspacing="1"> <form...
6
2271
by: hotflash | last post by:
Hi All, I found a very nice ASP bar chart code on the codetoad.com website. The author said, you can pull the values from a database as well. I am very new to the ASP environment and this stuff is way over my head. Can any EXPERT give me a hand here? If you know of something even better please advise. Thanks in advance for your help.
7
2400
kaarthikeyapreyan
by: kaarthikeyapreyan | last post by:
my apache 2 server displays a blank page when i run this code <html> <head> <title>PHP Test</title> </head> <body> <?php echo '<p>Hello World</p>'; ?> </body> </html>
1
1303
by: gagandeep27683 | last post by:
how to display the data in gridview whatever we enter in the textbox. Like we have enter the data in the Textbox,click at the button and it should go to databse and search for data and show it in gridview
0
2244
by: abdulazees | last post by:
when click button i want to print autometicaly reportveiwer data, i not need to show reportviewer.
11
2373
by: mylixes | last post by:
I'm currently developing a windows application. I have two forms, Form1 and Form2. They are both open. In Form1, I have two dateTimePickers (start date and end date), two text boxes (no of records and no of days) and two buttons (submit and cancel). In Form2, I have a dataGridView that displays data from a text file. For example, I set the start date from form1 as May 5, 2010 and end date as May 6, 2010. After i click the submit button,...
0
8428
marktang
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...
0
8851
Oralloy
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...
0
8747
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8528
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8627
tracyyun
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...
0
5649
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();...
0
4335
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2752
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
2
1976
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.