I'm trying to set up a database to track a huge group of corporations. There is the parent company, then a bunch of subsidiaries below it. Some subsidiaries have another layer of multiple subsidiaries below it, some have none. Any thoughts as to how to do it???
View Repliesa co-worker set up several pivot charts in queries, that we now need to get into a distributable format. I had envisioned having these in a report, but access doesn't agree. Is there any way of getting the chart out of access, intact, to place in a word or power point file, or into a report? My attempts to get the chart into a report have all ended with the table-like grid coming up. Surely there's a way...
thanks!
I have a couple charts that I would like to show on my switchboard. Right now I only have one that is up everytime I open my database. Is there anyway to have it do a random Sub form show up everytime you open the database up? Thank you for your help. Without this forum I would have shot myself a long time ago!
View 1 Replies View RelatedI have created a pivot chart using the Autoform and now i want to export this charts to powerpoint, i cannot copy that chart which i have created in in autoform, i can export the pivot table to excel sheet and draw again the chats but i cant copy or export the pivot charts directly, Is there any option for that. can anybody help me in this case?
View 2 Replies View RelatedHi, okay completely new to access. I'm trying to create a chart based on a query with 1 record 8 fields. I can not figure out a way to rearrange the data into two fields 8 records.
The background is I have a hundred units, each with 8 wheels. I have a table with the following fields.
-Unit part number
-Diameter of wheel 1
-Diameter of wheel 2
-Diameter of wheel 3
-Diameter of wheel 4
-Diameter of wheel 5
-Diameter of wheel 6
-Diameter of wheel 7
-Diameter of wheel 8
So, the query tells me how many wheel diameters between a certain range, with the following fields:
- Diameter >530
- 530> Diameter >540
- 540> Diameter >550
- 550> Diameter >560
- 560> Diameter >570
- 570> Diameter >580
- 580> Diameter >590
- 590> Diameter >600
Now I want to plot the range on the x axis and # wheels in that range on the y axis of a bar chart.
Any suggestions on how I can achieve this? How do I create the diameter range as a record rather than a field?
Many thanks!!!
I have an application in Access 2003. It uses VBA to open an Excel file. The file has one tab for charts and one for data. The program counts how many charts needs to be created, one per project. It then will place 4 charts per tab, creating as many chart tabs as necessary, keep one data tab. The program then writes the data and links the data to the corresponding chart. It will also write legends, and scale the charts. This all works fine under Access 2003/Excel 2003.The error I get is "Application-defined error or object defined error".The line that gives me the error is: Set chCopy = xlsheet.ChartObjects(idx).I am using the Multi-Chart option frmChartType = 1
Now I'm moving to the Office 2010 world. It is not working. Below is the code I run to do the magic. I guess something is happening in Excel 2010 that is different from 2003.I found when I comment out the error line, and other lines dependent on chCopy it creates the charts, but all the charts are pictures and not charts!!
Code:
Public Sub GenerateChart()
' Generate an Excel chart
Dim db As Database
Dim rst As DAO.Recordset
Dim xlapp As Object
[code]...
I've developed and used over the past 20 years to handle my home finances. It includes several charts that were probably created back in Access 2003, which I used up until a couple of weeks ago when I subscribed to Office 365 Home and set up Office 2013, including Access.Most things worked without a hitch. In fact, all my old VBA code seems to run just fine.
However, the charts don't work. The right side of chart gets cut off way short of the margin both in print preview and report view. Everything else looks fine and the data is correct.
I've fiddled and fussed and fangled with zoom, clip and stretch. I've tried to resize the chart area - it just snaps back. I've tried everything I can think of based on 20 years of fussing with Access charts - which has always been a major pain - without success.
I am using this code it is giving me error 3828 at the line marked red. Says cannot reference a table with multi-valued field using an IN clause that refers to another database. Query has fields which gets input from combo box but only one value is saved in it.
Code:
Dim xl As Object ''Excel.Application
Dim wb As Object ''Excel.Workbook
Dim ws As Object ''Excel.Worksheet
Dim ch As Object ''Excel.Chart
Dim myRange As Object
Set xl = CreateObject("Excel.Application")
[Code] ....
I am using an Access 2003 database to create a Word report that contains Graphs. We have since moved to Office 2010, and now the vba code will not select the graph and populate the data, i presume this is because the data is no longer in a datasheet but Excel itself.
View 2 Replies View RelatedI have created a series of pie charts in reports based on queries. The data that is being charted are agree, strongly agree, neither agree nor disagree, disagree, and strongly disagree. I want the colors for these to be consistent in all the pie charts but they are coming out different colors on each chart: i.e., agree may be blue on one pie chart but yellow on another pie chart. How can I change the colors either in the pie charts or legends so that they are consistent on all the pie charts?
View 1 Replies View RelatedHello- I am trying to create a database for a non profit. One thing it needs to do is track donations- So I have a contacts table, and a donations table-
My question is, A couple will make a donation- each has a seperate record in the contacts table, but I would like to be able to track the donation by each person- if that makes sense. So basically, it would be two people(from the same table) making one donation. Is there anyway I can do this?
Thanks for any help!
Hello,
Can someone tell me how to set up a track changes in Access?
Thanks,
Kelly
Hi all,
I want to create a 100% stacked column chart (as can be used in Excel) into a report in my database, however I cannot find it anywhere to use.
Does anyone know if it is possible to use this type of chart in Access and if so, how to do this?
Again, help would be greatly appreciated.
Thanks
Hi everyone
I would like to create a statistical cusum chart in my db, I can do it in Excel but it's quite difficult to do in Access. Does anyone know how to do one, or know of any SPC add ons for Access (there are loads for Excel)?
Thanks
Matt
I would like to create a report from one of my existing queries. I would like this report to have a pie chart on it showing results from a field called concerns in the querie.
I would like the chart to break down the amount of each concern listed i.e. 4 of this 3 of that 5 of those etc.
i use the chart wizard to pull in the field data and when I click finish, it gives me basically nothing. Any ideas?
thanks in advance.
I solved one problem only to hit another.
I have several charts that work off of a query.
The several charts all compare various variables to year.
I created the charts and they all work great. However, the user now wants to be able to select or compare various years as opposed to seeing them all in every chart. I made the year an integer. I then tested the query that all the charts are based on to see if it filters properly.
In the query's date filed I have the criteria Like [Enter the desired year]
This works fine if I am just looking at the query.
However, if I pull up the chart that the query is based on I get the error message, "The microsoft jet database engine does not recognize '[Enter the desired year]'as a valid field name or expression."
I have wasted an enormous amount of time simply trying to filter my charts by year. A single field in my table that is an integer with 0 decimal places. All the dates are entered as a 4 digit number. Ex 2006.
Any help / suggestions would be greatly appreciated.
My end desire is to have a form with two text boxed named "start" and "end" in addition to a number of butons each corresponding to one of the charts. My user will enter two dates, one in each of the text boxes "start" and "end"
When he/she presses one of the chart butons, the corresponding chart will open up showing only the two (or) one selected years' data. This would be filtered by the query that all of the charts are based on that has a set criteria, "Like [forms].[charts].[start] or like [forms].[charts].[end]"
As I mentioned earlier, I already have this all set up. The query works fine based on all of the above. However, if I click the butons or try to open a chart I get the message stated above.
Thanks again to all here at the forum for your invaluable help.
Deal All
I've got some simple charts to do in Access. They are working fine - except for the Legends.
The problem is that my table (on which the charts are based) is fed by Combo boxes which populate the table with codes, rather than a descriptor.
For example, the combo box on the input form displays two columns
5 | Excellent
4 | Very Good
3 | Average
2 | Not good
1 | Poor
0 | Don't know
..but populates the table only with the numbers 5, 4, 3, 2, 1, or 0.
Consequently, the legend in my graph only displays the numbers - when I would really like the Words.
What's the best way round this?
NoVoice
Hello,
I am adding a chart to my switchboard page which comes from a query...does anyone know if this is ok to do or if its not recommended. The Chart takes the database and summarizes its contents..
Didnt know if performance issues would come into play...
Thanks for any opinions.
thought this might have been easy, but no....
i want to have a form with a [DateFrom] and [DateTo] text box
you click a button, it goes to a chart and the chart is filtered between those dates (the chart has week along the x axis)
problem is, the recordsource of a chart in a report is a crosstab query and you can't put form filters into a cross tab query
have tried to ram the parameters in before opening it with
CurrentDb.QueryDefs("qry_Reporting_Charts").Parameters("DateFrom").Value = [txtFrom]
CurrentDb.QueryDefs("qry_Reporting_Charts").Parameters("DateFrom").Value = [txtTo]
DoCmd.OpenReport [cmbReports].Value, acViewPreview
but it looks like the parameters are read only or something :confused:
any ideas anyone?
thanx in advance
Hi, I have done a search before posting but cannot find what I am looking for.
At work I use a database to record incidents (work that I do). I have written a query for incidents for 2007 and 2008 and I can do a line graph for each year showing the monthly incidents by doing Insert, Form, Chart Wizard
What I am trying to do is a line graph for 2007 and 2008 together to compare performance but i can only ever choose one query for my graph, either 2007 or 2008.
Is there a way I can get both years on one graph so as i can compare performance.
Any help/guidance appreciated.
I am infuriated with MS Access now!!!!!
I am building a nice little system and now I am developing the reporting features. I want the results of a query to populate a chart.
Basically it is a monthly chart, so would have 12 months along the x axis and a quantity on the Y. A simple line chart!
I want 4 different lines each representing a form of occurrence. However Access limits you to using a maximum of 6 fields! Are you serious!!! I need 12 just for the months!!!!
Is this a serious feature of Access or am I being stupid?
I know many people who export a lot of stuff to Excel for charting, and now I know why. Is this my only option? I wanted to avoid multiple applications, but if I have to, will have to learn how to automate to an excel template, some thing I am not aware of how to do currently and am limited in my VB programming abilities.
I cannot believe that a powerful tool such as Access could be sooooo limiting in it's reporting capabilities!
Hi guys,
i have built a query to find the sums of various fields from various tables. i want to make ONE piechart from all these the sum values... i.e.
Cars - 500
Planes - 300
Those digger things i always wanted as a kid - 200
But the stupid MSchart activex thingy in Access 2007 always wants to Sum/max/be an idiot to the data. All i want is a damn pie chart!
Any ideas?
If it can be done in VB by saying "split the piechart into 3 pieces. One = Cars, two = Planes, three = diggers" - that would be ace
I am trying to create a chart on a Form. In Excel I have no problems arranging my data. This is my first try for charts in Access. I have a table. I created a query summing two fields of this table:
Total Workers
Total Workers: DCount("[WorkerNameLast]","1-StationVerifyTbl","[ClockNbr]<>'*'")
Total Workers = 120
Total Verified
Verified Workers: DCount("[WorkerNameLast]","1-StationVerifyTbl","[StaPrimary]=True")
Total Verified = 43
So far so good. That is the correct information. What I want in a Chart is two bars side by side. One bar at 120 and the other bar at 43. I have tried everything and cannot get this to work. I am getting confused on the Axis, Data, & Series. I think I need another Field somehow. The totals I would call Monthly Totals
Could someone please help me get this thing started. I have wasted a week and feel like I have learned nothing except how to count in the Query.
After this I would like to be able to show a percentage of those verified. I have 120 workers and 43 are verified. That would be approx 35%. Anyway I am assuming that there is a solution and that I am just floundering for nothing. Thanks in advance.
CAN THE FORMAT OFF THE WEEK NO USED IN PIVOT CHARTS BE CHANGED THE DEFAULT WEEK NUMBERING SYSTEM IS NOT COMPATIBLE WITH THE ENGLISH WEEK NUMBERING SYSTEM. I CAN WORK AROUND THE PROBLEM IN VBA CODE BY USING DATEPART("WW",DATE,VBMONDAY,vbFIRSTFOURDAYS) WHICH RETURNS WEEK NO IN LINE WITH THOSE USED IN ENGLAND BUT THE PIVOT CHART DOSEN'T SEEM TO OFFER THE OPTION OF WHICH WEEK NUMBERING SYSTEM TO BE USED ANY IDEAS!
View 2 Replies View RelatedI have a bunch of charts in my forms, and my boss wants to be able to adjust axes. I have added a context menu that brings up a little form and takes values that are then thrown into the graph by way of a function. URL....Here's the current code:
Code:
Public Function AdjustTREFAxis()
'See form fTREFaxis
Dim objChart1 As Object
Dim objAxis1 As Object
[code]....
notes:
-ignore the global vars, they are a temporary measure.
-"Graph19" I know, not good. I never expected to call it in code though , I'll fix it later
-the while loop keeps the rest of the code from running until the axes have been submitted.
Ok, so this code works for the x and y1 axes. I assumed that Axes(3) would iterate to the Y2 axis, it does not...I also found that after you change the axis the changes are persistent for the graph even upon repaint/requerying it. This is problematic and I need a way to set an On Load event that resets the graph to "autoscale"
Lacking that, how to access the Y2 axis, or how to reset the axes to autoscale that would be keen.
Hello,
I recently started using the Chart feature in access. Everytime the form with the graph loads up windows installer pops up and asks me to install. Since i let it install like 3 times, i click cancel and it still works fine. Anyone else have a problem like this? How can i prevent it from installing everything, since its already installed?
Matt