Best Practice For Charts?

Jan 3, 2007

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

View Replies


ADVERTISEMENT

Good Practice Or Bad?

Mar 9, 2006

A developer where I am contracted to constructs his If statements like this:
If Day(Now()) <> 1 Then DoCmd.OpenQuery "qry_06c_Get_CurMon_Rebates"

Instead of like this:
If Day(Now()) <> 1 Then
DoCmd.OpenQuery "qry_06c_Get_CurMon_Rebates"
End If

All on one line and no end if needed. I didn't even know that would work.
Is this good or bad practice from a coding standpoint? Any Pitfalls?
Thanks

View 5 Replies View Related

Best Practice: Multiple Values

Feb 25, 2008

Hi All,

I'm a relative newbie to Access - I am wondering the best way to solve a problem. I am the admin for a database used to track projects and the quality control process. With this process we must keep up with the review of another database, the pieces of information entered which are erroneous and when the individual responsible corrects the data. To date, the errors have been manually typed into a memo field which is then pushed out to the end user in a report. The errors are very consistent and I want to create functionality that will allow me to select the errors (there are approximately 50 standard errors) from a list or using a button or whatever is wisest. Basically, I would love some best practice opinion here as I am totally stymied at this point.

Any advice for a weary admin?

View 14 Replies View Related

Multiple Practice Groups For One Person

May 27, 2005

Hello,

I'm creating a simple relational database of all the attorneys our company work with. I'd like to have three tables: "Law Firms" (firm name & other info), "Attorneys" (what firm, personal info, and what practice groups s/he is involved in), and lastly "Practice Areas" (all different practice areas with codes).

Now, my issue is that people are usually involved in multiple practice areas. Thus, I can't just put a code for one practice area in "Attorneys" table, but I can't put multiple codes in either in one field (right?) because it'd mess up the relations.

What I'd like to accomplish is for people to be able to go to our intranet and, using a form (?), select a law firm and a practice group and get a list of attorneys.

Does anyone know of a good way to solve this? It doesn't have to be pretty, since the DB isn't going to be huge (2000-2500 records).

Thank you!

View 3 Replies View Related

How To Create A Template For A Medical Practice

Oct 26, 2012

I am just wondering if theres a way I can create a customise database for my workplace. We are looking at replacing the old record cards that sit on the desk that records each clients visit and the price they paid. We do use MYOB for all our accounting etc but we are wondering if there is a way that we can create a database that enables us to record the date and price paid for each visit for every individual client?

View 4 Replies View Related

Is Trimming Field Size Where Suitable Good Practice?

Jun 6, 2007

If I have a DB with several tables containing thousands of records, and most of those records only ever need say 8 characters, does anyone know if changing the field size from default 255 chars to 8 chars will actually benefits the the DB?

Potential benefits I'm thinking may occur are reduced filesize and maybe some speed?

View 3 Replies View Related

Best Practice To Handle Poor Data Quality In Relationships?

Jul 21, 2007

I'm attempting to normalize an enormous table with order data, but I'm running into some problems. The table currently contains many duplicates, of which also included the actual order information (yikes!), but I managed to normalize it almost all the way down. It appears that different accounts can be used on orders, and these order numbers are being recycled for some reason months down the line (don't ask my why they're reusing them for future orders because I have no idea either, they should be creating new order numbers). Of course, the Order number is the primary key in my table as it should be. I guess the same thing can occur with the sales rep. Anyway, I'm struggling to find the "best practice way" to deal with this situation. I'm almost tempted to create an intermediary "transaction table" or something like that between the main general order information (which at this point will basically be the Order Number and Customer ID only), then include a table with the account information and sales rep info, then have that link to the Order Detail with the products, quantity, order number and various dates for those order numbers. Order maybe it should be a separate, related table, but not between the general order information and the order details? Can anyone tell me if I'm on the right track for this situation? It was a total curveball that the rep and account information could be different on these orders.

Option 1:
Order (Order #, Customer) -> Transaction Information (Order #, Account Type, Sales Person) -> Order Details (dates, products, quantities, etc)

Option 2:
Order (Order #, Customer)---> Transaction Information (Order #, Account
| Type, Sales Person)
|
|-> Order Details (dates, products, quantities, etc)

View 2 Replies View Related

Computer Disposal Best Practice: Table To Store Retired Hardware?

Jun 27, 2007

Hi guys. I have been working on a database to store network information, computers, software etc......

I have a table (tblComputers). I allocate computers to users on the network.

My question. When they come to the end of their shelf life I have the option to delete them from the database. However once deleted I will have no record of them. So I thought......would it be better to create a seperate table and move them there, or add an additional check box within tblComputers 'Retired' then add some code to prevent allocation?

Advice warmly received as always.
Phil.

View 2 Replies View Related

Charts

Jan 6, 2005

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

View 4 Replies View Related

Cusum Charts And SPC Add-ins

Aug 7, 2006

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

View 1 Replies View Related

Charts In A Report

Jan 4, 2008

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.

View 2 Replies View Related

Filtering Charts

Aug 25, 2006

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.

View 2 Replies View Related

Anyone Try Tracking Org Charts In Access???

Jul 6, 2006

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 1 Replies View Related

Charts In Switchboard? Any Issues?

Jan 24, 2007

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.

View 1 Replies View Related

Charts With Filters From A Form

Nov 13, 2007

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

View 2 Replies View Related

Creating Charts From Querys

Feb 4, 2008

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.

View 9 Replies View Related

Charts From Queries - 6 Fields!!!!!???? Is That It!!!!???

Oct 17, 2007

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!

View 1 Replies View Related

Pie Charts - Why Aren't They Simple?!

Feb 25, 2008

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

View 5 Replies View Related

Charts Driving Me Crazy

Jul 19, 2005

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.

View 8 Replies View Related

Getting Pivot Charts Out Of Access

Nov 24, 2004

a 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!

View 3 Replies View Related

Week No's On Pivot Charts

Feb 1, 2005

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 Related

Forms :: Modifying Charts With VBA

May 6, 2013

I 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.

View 1 Replies View Related

Different Sub Charts Everytime Access Opens

May 4, 2005

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 Related

Pie Charts - Keeps Asking To Install Microsoft Graph!

Mar 4, 2005

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

View 1 Replies View Related

Linking Charts To Listbox Question

Mar 10, 2005

I have a simple table with fields Date, Parameter, Value. On my form I have a Parameter listbox and a chart. Once a parameter is selected I want to display the chart which shows all the values for the parameter by date. Then I want the user to be able to select a different parameter have the chart display the values by date, etc. Sounds easy. It's driving me nuts. The only way I've been able to do anything close to what I want is by linking the chart to the Parameter field in the table and using the Record Selector button on the bottom of the form and of course this is a totally unacceptable solution. All suggestions will be much appreciated.

View 1 Replies View Related

Access Pivot Charts In Powerpoint

Apr 1, 2004

I 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 Related







Copyrights 2005-15 www.BigResource.com, All rights reserved