I am using Access 97 to build my Database. I would like when my query is run, to populate a graph from the results of the query. Currently I am using a form to populate the query, and the query is then displaying the resulting records into a datasheet view on a subform. It is the resulting records I would like displayed on the graph. The fields I want on the graph are Prod_Code and Claim_Date. Thanks for the help.
10 3675 NeoPa 32,569
Recognized Expert Moderator MVP
I'm not even sure Access does graphing (I'll probably be proved wrong here).
Excel, of course, handles them very well. Might that be a viable solution?
nico5038 3,080
Recognized Expert Specialist
Did you try to insert a Graph object on a form ?
Just use your query as the source.
Nic;o)
Yes, I am using the insert graph function, and referencing my query. The problem is that the when the form is opened, the query is run by the graph and produces useless data. I need it to wait until I run the query from the form.
nico5038 3,080
Recognized Expert Specialist
Hmm, for this type of timing problems I use to switch from a query to a temp table as a source for the graph. Is changing your query into a maketable query an option ?
Nic;o)
NeoPa 32,569
Recognized Expert Moderator MVP
Yes, I am using the insert graph function, and referencing my query. The problem is that the when the form is opened, the query is run by the graph and produces useless data. I need it to wait until I run the query from the form.
I've never used this myself, but if it's like forms and reports then it will have a RecordSource or DataSource property somewhere. Is it possible to leave this empty in the design of the graph and populate it using VBA code as-and-when you're ready for it to work?
No, I can not make it a make table. I will try to tamper with the record source.
This is what the chart lists as the Row Source. - TRANSFORM Count([PROD_CODE]) AS [CountOfPROD_CODE]
-
SELECT (Format([CLAIM DATE],"MMM \'YY"))
-
FROM [Labor Query]
-
GROUP BY (Year([CLAIM DATE])*12 + Month([CLAIM DATE])-1),(Format([CLAIM DATE],"MMM \'YY"))
-
PIVOT [PROD_CODE];
Any ideas how I can alter this to do what I am looking for, which is make the graph once I run the query. I am using the Insert chart function.
NeoPa 32,569
Recognized Expert Moderator MVP
I'm not sure what you want done differently.
Basically, you put something very like the code that's there already. Changes would be made depending on what you require to be different from the original.
I'm not sure what you want done differently.
Basically, you put something very like the code that's there already. Changes would be made depending on what you require to be different from the original.
It is running without me telling it to, basically. I need to do something similair to chaning its record source on the fly. Any ideas?
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Florian Lindner |
last post by:
Hello,
I'm looking for a program or python library to draw graphs.
They should look like the that:
/--------\ /--------\
| Node A | ------ belongs to ----> | Node B |
\--------/ \--------/
Which is a result of the function call like that:
|
by: MJR |
last post by:
Hi,
just wondering what options I would have if I wanted to use Python to
produce real-time graphs. Is there any plotting package suitable for
this.
Thanks,
Mike
|
by: MooMaster |
last post by:
This is more of a wxPython centric question, but not seeing reference
to this on the wx group I thought I'd try here since many here also use
wxPython toolkit. I started learning GUI development with Tkinter, and
developed a few screens as part of an application I'm building with it.
I've recently been trying to learn wxPython because of it's additional
widgets (the wxTreeCtrl and Drag and Drop features in particular), and
I've developed...
|
by: Deborah V. Gardner |
last post by:
I would like to use "Yes" and "No" checkboxes on a subform. The problem
is that when I click the Yes checkbox on the subform, all of the
checkboxes are checked.
Currently, I have a field "Refused." It is defined as a text field. A
"Y" means that the service has been refused; an "N" indicates it has
been accepted. If the field is Null, the question has not been answered,
i.e. we don't know if it has been refused or not.
I want the user...
|
by: Kathy |
last post by:
What is the standard technique for handling the fields in the following
scenario on a continuous form?
Multiple Divisions. Each Division has multiple Buildings. Each Building has
a Supervisor.
Tables: (abbreviated)
TblDivision
DivisionID
| |
by: Panther240 |
last post by:
How can I develop graphs(Pie Diagrams,Charts etc...) in ASP.net.I want
to display the graphs in a browser.I have a SQL Database from where I
pull the data to display in graphs
|
by: google |
last post by:
I'm developing an application for use within my company in Access 2003.
I'm new to '03, the application I did for my former employer was in
'97. The two applications have similar functionality (we're sales
offices, and I'm doing things such as associate directories, commission
calculations, order tracking, etc.). 2003 seems to have a few extra
features, but I seem to continually run in to oddities that seem like
they SHOULD work, but...
|
by: robert.q.johnson |
last post by:
Help. I am trying to create a web page in C# to display two rows of
data
with bar graphs (an image 1px). I get the max value of the row and use
the following formula to size the height of the image, but the bar
graphs are not sizing correctly. Can anyone provide me with a solution
or any ideas.
rowValue / maxRowValue * maxBarHeight
|
by: Regnab |
last post by:
I've got a form - "frmLookup" (with a subform) that works very happily
on its own. The form has a list box, which when updated requeries the
subform to display the appropriate results.
The problem is that for the final user interface, I had planned to use
a "frmDisplay" form which had a number of menu items and then depending
on what the user selected, it would display the appropraite form in a
subform beneath the menu items. I did this...
|
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: 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...
|
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,...
|
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: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |