Different Group Levels For Pivotchart In A Form
Hi,
I know we can set different group levels when we create a report, can we do the same thing for a pivotchart in a form? Thanks!
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Form(pivotChart) Save As Data Access Page
Hi, I tried to save two Forms (PivotChart) as Data Access Page, the first one works , but the second one just displayed an empty graph (two axes). The forms were generated from two different queries which from the same tables. Any ideas how to solve the problem? Thanks! glenn
View Replies !
View Related
PivotChart Report
I have a report with an embedded PivotChart. When I export this report, the PivotChart can’t display in MS word file. How should I do to export a report with a PivotChart to MS word file format? Thanks
View Replies !
View Related
PivotChart Only On First Page
Hi, I have a PivotChart embedded in a Report using a master/child relationship (to the field [Course ID]). The chart works fine on the first page of the report, showing just the data for the first course. However, on subsequent pages there is no chart shown at all. If I remove the master/child link then the summarised chart appears on all pages. So whats going on? - I'm sure this worked a couple of days ago. Not sure if it failed when I ran an Office update in the last few days. The PivotChart is a form used directly on the main report. The main report has a [Course ID] Header and footer. The PivotChart form is in the detail section. Access 2003, recently updated, on XP. Thanks, Darren
View Replies !
View Related
Creating Custom PivotChart
I am trying to make a special kind of blob chart. It has to mimic the charts I have attached. I have a high number and a low number for everything that someone might want to put on the axes. The eventual goal is to have a form were the user selects what goes on each axis, and have a few other possible choices to limit how much is displayed. What I am making doesn't have to be as fancy, flexablity is more important. Can Access make this kind of graph or am I on my own, making shapes in VBA? http://www-materials.eng.cam.ac.uk/mpsite/interactive_charts/energy-cost/generics.jpg http://www-materials.eng.cam.ac.uk/mpsite/interactive_charts/energy-cost/metals.jpg
View Replies !
View Related
Rolling Average In PivotChart
I have a multi-pivotchart I am using to display data. Each chart shows a score for the month (taken from the date field). What I would like to do is display the three month average as a fourth column in each chart. (or at least the average alone since I only show 3 months anyways) i.e. jul, aug, sept, ave I have an average column under grand total in pivot table view but I cannot seem to translate this into a pivotchart that displays what I describe above. I do know this is far easier with MSGraph but I want to use pivotcharts for various reasons. Any help is greatly appreciated.
View Replies !
View Related
PivotChart Export Into HTML
I've a query that gathers data from another db via ODBC. The query takes a fairly long amount of time to run. The query outputs a PivotChart. I want to save/export this PivotChart as HTML and load it up on a webpage. I could probably do this by saving as a DataAccessPage but that would mean running the query at the time of accessing the website. So, I want to avoid this long delay by saving it as HTML. I also want this HTML PivotChart to have the ability to "pivot" the categories by filtering/removing/adding categories that you typically do in a regular PivotChart. The 'Save As' option does not have the HTML option. Exporting to HTML only exported the text data but not the PivotChart itself. I'm very certain this can be done. I know this can be done because I had done it once but now can't remember. Can anyone help?
View Replies !
View Related
Queries - PivotChart View
I am made a query, but I want the query to always open up in the PivotChart View...how do I do that? Even simpler: I want to have a button created on the initial form that opens when database starts, which will then open the pivotchart view with the person having the ability to drag items in the chart field list to create a chart to their liking, holding the data accordingly. Please Help!
View Replies !
View Related
Sorting Query & PivotChart
Hey everybody, I know this question maybe be very lame but its been ages since i've touched on my sql knowledge. I've set out my database and i have 1 table which is holding the info i need to extract so that i may put it into my report. I wish to count the different values in a specific row: Example: Whats the problem Behavioural Physical Physical Behavioural I wana be able to count these seperately as in: SELECT COUNT(Client.[Whats the problem] LIKE 'Physical') AS Phy AND COUNT(Client.[Whats the problem] LIKE 'Behavioural') AS Beh FROM Client; Result: Phy Beh 2 2 I havent got a clue if i'm doing it right but i need to get it to work in access 07. Also one more question i have created a Pivotchart in a form but when a create a button on my main startup form and click into the Pivotchart form all i get is the Datasheet view, how can i get it to open up the Pivotchart through the form. Any info would be greatly appreciated Thank You.
View Replies !
View Related
Why On Earth Is My Access PivotChart Doing This?
I've written a couple queries in Access that create a BOM for components that we sell in our company. The data is withdrawn from our company system into a pyramid structure (MACOLA). Basically, all I did was recreate the "Indented Bill of Materials" report from our system. However, when I try to run the data through a PivotChart Form, it truncates all the data (i.e. if I need 16 of one component to make another, the chart will display 16 as it should, but if I need 4.75, it will display 4). The data in the final query where the report is drawn from is correct. It displays numbers both whole and decimal. I've looked everywhere in the properties to try to eliminate the problem, but I haven't found anything. How do I fix this? P.S. I've developed other PivotCharts that don't have this problem. I've even rewritten the queries using a different approach with the same results. Any Ideas? Thanks in advance.
View Replies !
View Related
Pivotchart Report First Record Only
I am trying to follow this Microsoft Tutorial and it worked when I put the subform (pivotchart) into a form but not when I put it into a report. The report shows the pivotchart correctly filtered for the first record but the chart is blank for the rest of the records.
View Replies !
View Related
Access Levels
Iv got a user table with an admin record and head teacher record with the highest access level I then have 2 teacher records with a lower access level The admin and headmaster have access to the whole system this includes assigning user name and passwords. However I don't want the head master to be able to change the admins password, so is there a way to lock this record or even hide it from a user form
View Replies !
View Related
Stock Levels
Hi hope someone can help. Thankyou in advance. I have a small database for my warehouse that sells washing machines, fridges etc. I am trying to get a grip on the stock control. What I am looking for when a order is filled out on our order form is the stock number will reduce by the amount sold. Not sure how to make this happen. I have the number of units in stock under the products table ProductsID PK ModelNumber UnitPriice Description QuantityInStock Sounds simple but for some reason I cannot figure it out. Thanks Kim
View Replies !
View Related
Stock Levels
hello, i am new to this forum. i have been struggling on a project i am doing where i am tring to calculate the stock levles and keep track of them along with the re order level i have calculated the current stock levlel, in a query called "stock level 3" Here the total amount prodcuts sold are taken from the field called stock level. Here is a break down of my original tables CUSTOMER Cu ID And all their personal details such as contact details CUSTOMER ORDER This is where the order takes place and contains the following information Order_ID Cu_ID Staff_ID Order_Date Required_Date Recievied_Date Order_Total Delivery Delivery costs Overall discount Type-Of_Purchase Paid Money_Owed Final Costs CUSTOMER ORDER DETAILS Here is the specific details of one order. Order_ID Prod_ID Qty_on_Order Discount Line_Total PRODUCTS Prod_ID Supp_ID Product_Name Product_Type Prod_ Unit_Details Qty_in_Stock Re_Order_level Price Unit_Cost Manufacturer_ID Shelf_Life SUPPLIER TABLE – with detaisl e.g Supp Id and account number SUPPLIER ORDER Supp_OrderID Supp_ID Date_Ordered Date_Required S_Delivery_Date S_Order_Total Money_Owed Delivery Driver Supp_Credit_ Limit Overall discount VAT Type-Of_Purchase S_Paid Supp_Final_Costs SUPPLIER ORDER DETAILS Supp_OrderID Prod_ID Qty Unit_Detials Qty_Recieved Discount Line_Total QUERIES •In the query “All customer order details”, I have worked out the line total for each prodcut with in one order. I have timed the Qty_on_Order (customer order details table) by price (in the produt table) and by the discount(customer order details) this then gives the line total Now to update the stock level I made a new query called “stock level Query”, where I added up the total number of each products sold, by adding the “Qty_on_Order” from the query “All customer order details” I then made a new query called “stock level 2” where I calculated the amount left on the shelves by taking “SumOfQty_on_Order” of each product from “Qty_in_Stock” (form prodcuts table) to produce the field called “Qty_in_Stock” I then made a new query called “stock level 3” where I inserted the same fields but an extra field called “Re_Order_level” for some reason could not add this to the query "stock level 2" So far the system can add up the total number of products sold, for all the orders, and then automatically calculate the Qty_ in_ stock by taking away the “SumOfQty_on_Order” once a new order is made. I then made forms where I go in my form to “customer”" and then to “making new order”. Below is a sub form called “all customer order details sub form” . Here orders are made with defining "Qty_on_Order I want to make a system which calculates for me i have ordered more stock then there is. Howcan i now when i make sure when i place a new order in the query"All customer order details" , that if i order above the number of "Qty_in_Stock" (from query srock level 3), from the query “stock level 3”, that when I order more products then ““Qty_in_Stock”, in the query “stock level 3”, does not allow me to enter this and if it is possible please can you insert error messages on it. I do not know if this helps .- I can not make the “Qty_in_Stock”, to appear in the actual table “Products”. At the moment I can only update this in the query “stock level 3”. I am not sure if I need this so I can then set re order level which then comes up with an error message telling me when the re order level has been reached. - As later on I will need to add on any products brought in from the suppliers to the Qty_in_Stock”, in the products table to be automatically updated. "stock level 3". here are the fields Code: Prod_ID (Products) Prod_Name (Products) SumOfQty_on_Order (from "stock level Query") Qty_in_Stock: Products.Qty_in_Stock-[SumOFQTY_on_Order] Re_Order_level (Products) here are both sql from both queries All customer order details Code: SELECT [Customer Order Details].Prod_ID, Products.Price, [Customer Order Details].Qty_on_Order, [Customer Order Details].Discount, (Products.Price*[Qty_on_Order]* (1-[Discount])/100)*100 AS Line_Total, [Customer Order Details].Order_ID, Products.Prod_Name, Products.Prod_Type, [Customer Order].Cu_ID FROM [Customer Order] INNER JOIN (Products INNER JOIN [Customer Order Details] ON Products.Prod_ID=[Customer Order Details].Prod_ID) ON [Customer Order].Order_ID=[Customer Order Details].Order_ID ORDER BY [Customer Order Details].Order_ID; stock level 3 Code: SELECT [All customer order details].Prod_ID, Products.Prod_Name, [stock level Query]. SumOfQty_on_Order, Products.Qty_in_Stock-[SumOFQTY_on_Order] AS Qty_in_Stock, Products.Re_Order_level,Products.Prod_Name, [stock level Query]. FROM (Products INNER JOIN [All customer order details] ON Products.Prod_ID = [All customer order details].Prod_ID) INNER JOIN [stock level Query] ON Products.Prod_ID = [stock level Query].Prod_ID GROUP BY [All customer order details].Prod_ID, SumOfQty_on_Order, Products.Qty_in_Stock-[SumOFQTY_on_Order], Products.Re_Order_level; please may help me and gice m,e soem tips it will be much appreciated or website/downloads. Thankyou for your help, and if you find easier ways to do this can you help me. Thank you so muh.
View Replies !
View Related
Avoiding 20 Levels Of Iif-Then-Else
I'm sure there's an easy solution to this somewhere... I have a query that is supposed to assign a wage to a production job if the range output falls within a certain percentage range. For example, if they produce 125% to 130% of their goal, their wage is 15 cents higher. If it's between 130% and 135% of their goal, their wage is 30 cents higher. There are about 20 ranges that my bosses want set up. Short of making the longest Iif-Then-Else statement in history, does anybody have any suggestions? Should I use a separate table and somehow try to integrate it into the query?
View Replies !
View Related
Pivotchart With Series On Different Scale Axes
Hello all. My client has decided they like the pivotchart format better than the regular chart format, especially for its dynamic quality ( it can expand and contract with form adjustments. One chart I am having trouble replicating in pivotchart format is one that plots two data series. One series is made of columns representing large numbers, generally several hundred or thousand, and the other data series needs to be a line which usually ranges between 0-10. Obviously they cannot be represented on a y-axis with the same scale. This is simple to handle in MS Chart. Is there a way to make a pivotchart with a dual-scaled y-axis, and map a data series to each one? Thanks in advance.
View Replies !
View Related
Using PivotChart To Display Survey Data
I have this pivot chart (please see attached screenshot) that I was hoping to use to display results of a survey that was conducted by our nonprofit organization. I have it filtering by a few demographics (age, gender, parental status), and then the results of a few other questions below it. My problem is that I'm not sure what results I'm looking at -- whether they're totals of all the responses, just the "true" responses, or...? The survey asked questions similar to what you see in the field list. Each question is a column header in my table. Then the row headers are each respondent. The choices for answers were "true", "false", or nothing. So in all the cells, i entered t, f, or nothing accordingly. I'm not sure if I'm not using the pivot chart correctly, or if I didn't design the table for the data correctly.
View Replies !
View Related
PivotChart Category(x Axis) As Variable
Hi all, I want to create a pivotchart from a query, embed it in a form and use a combobox in the main form to allow the user to select the x axis value. So in a query with fields city, state, country, etc the user would be able to chose one of those fields as the category(x axis across the bottom) to display data. Is this even possible? If it is, how do I do it? As it is now I can add multiple categories to my chart- but it just makes a big mess of the chart. I can embed a chart in a form and use a combobox- but it allows me to choose from within a field- but not from among fields. Also- how do I access the code to manipulate the chart? Thanx in advance
View Replies !
View Related
Macro Security Levels
Has any one found out a way to change Macro Security Levels!! Microsoft seems to have kept this as a secret. The code below given in the help files doesnt function. Application.AutomationSecurity = 1 or Application.AutomationSecurity = msoAutomationSecurityLow
View Replies !
View Related
Adding Stock Levels Together
I have a database which seems to open many copies when it is accessed over the internet (via ASP) but If I open it on my compter over my LAN then it seems to open 'exclusive' and those on the Internet get the error message that 'file is already in use'. So I have devised a method where I will make a copy of my database on my computer, clear all the stock levels and then add in the new stock. My question is - how do I write a query that adds the 2 stock levels together? James
View Replies !
View Related
Macro Security Levels
I've written a db which I will be putting on someone elses machine. I want it so there is a short cut that directly opens the db from their desk top. I'm happy about setting up the 'on open settings' so it goes to the default page etc, however what I do want to avoid is the macro warning at the start when access opens up. I know one way to avoid this is to drop the security level down from medium to low. It mentions that this is ok providing the machine in question has good anti virus software installed - which it does. So, here's my question. Is it really ok to drop the security level down or am I potentially going to screw up my mates machine . Alternatively, is there a better way of doing it Many thanks
View Replies !
View Related
Multiple Levels Of Data
I'm fairly new to access, having done a lot of what would have been easier with access in excel. I've decided to make the switch but need one particular thing that I can't seem to work out. I have a series of "Courses" which contain a series of "modules" and each module has various amounts of data that needs to be accessed. Is it possible to have module tables embedded in the courses table. Or, do I have to just have one massive table that contains ALL the modules with a field that says what course they belong to. Then make queries that display only the modules of that course? Or is there another way to do it? I also haven't gotten to learning about queries yet, so if this is the way to do, can anyone explain how or better yet, point to a tutorial that can explain how this is done?
View Replies !
View Related
Parent Form Vanishes When I Tab To Option Group In The Child Form?!
I have a rather annoying and frustrating problem which I cannot find a solution for through searching the forum. The situation is that I have a parent form with 1 unbound subform, the source of which is determined by the part number selected in the parent form (diffetrent parts have different fields of the source table displayed) This all functions perfectly well in all but one case which is when the source of the subform is a form with an option group. There is only 1 form like this, and the problem I have is that when tabbing through the fields, as soon as I tab into the option group the parent form disappears, and I am left with just the subform on screen! Clicking into the group is fine, just tabbing to it causes the problem, and if I remove the option group then tabbing through all the rest of the fields is fine... I could powssibly change the option group for a set of option buttons and code them to function a bit like an option group, but this would mean changing the code for numerous reports etc. and I don't really want to do that if I can help it.
View Replies !
View Related
Adding Security Levels For Different Users
I run a school library database (Access 2003) and want to set up a password logon system so that different users can get at different parts of the program - e.g. Administrator (everything), Librarian (can add and delete records but not change the database design), Student (can only access certain areas, read only). I've tried using the security wizard to set this up, which seems OK until you then open the database again. I would expect to then get some sort of log-on screen next time I open the database, but instead it opens normally, but then won't let me do anything because I "don't have permission". I had to restore a back-up copy. I must be missing something obvious here. Is there a place to look for instructions? Couldn't find anything useful in the help screens. Richard
View Replies !
View Related
Access 2000 Security Levels
Hi I have produced a database in Access 2003 and saved it as an Access 2000 format. However when it is used on PC's with Access 2000, some (not all) users are getting messages displayed when they open the database that Access cannot open the database due to the Security Levels. Can anyone tel me where I can find the security level settings on Access 2000, I've found them in 2003, but not 2000! Can anyone help. Thanks Steve
View Replies !
View Related
Counting And Checking N Levels In A Recordset
Hi, I need to work out how many components we have in stock that make up a Part - identified by being the PrimaryPart. Each part has a component, which in turn has another component, but different part have a different number fo sub-components, a simple display of the table I am using is shown below: ID PartName ComopnentID No. in Stock PrimaryPart 1 Part X 2 12 Yes 2 Part Y 3 14 No 3 Part Z 15 No 4 Part T 5 1 Yes 5 Part U 6 11 No 6 Part V 7 25 No 7 Part W 20 No The problem I have is that I need my vba code to check if there is a sub-compnent for the current part and if so make sure that is counted. So in the instance above Part X has 2 sub-compnents (Part Y, Part Z) and there are 41 bits in stock, whereas Part T has 3 sub-compnents (PartU, PartV, PartW) and there are 57 bits in stock. How do I get a script to recurse X number of times to check. Thanks
View Replies !
View Related
Normalize My Table - Track Price Levels
i would like to have a table where i can track price changes, however i don't want this to based on an inventory order. i have a table which has the amount of hours to be charged. i then have another table which has the price per hour charged. the price keeps on changing. both tables have the date. tableHours has the date of occurance and TablePrice has the date when the price was last updated. i need to know how to structure the TablePrice. currently it is set as BillableHourType, Rate, EffectiveDate. If this is correct, i don't know how to run a query. i need to multiply Hour*Price, criteria: Effective Date must be most recent date as of Date of Occurance. All Help will be appreciated. I posted this post on the Microsoft site and i got no good responses, i am new to this site, but if it is a problem of reposting, please let me know. i will not do it again. thanks, sam
View Replies !
View Related
Difference Performance Levels For Diff Users With Seemingly The Same Set-up?!
Afternoon Folks, I have a database that multiple users have access to. We all have new pcs of exactly the same spec. We all have the same oracle ODBC, which is linking to tables in an oracle database on a Sun F15k Server. The linked tables are set-up using my oracle account with saved password. We are using the same network. We are all using Access 97. Queries that are run in this database are returning results in just a couple of seconds for other users, and 20-30 seconds for me. Can anyone suggest any factors that may be causing this discrepancy? Or things that I can run/do to improve performance? Cheers in advance, James
View Replies !
View Related
PivotChart Decimal Place On Fixed Number Format On Averaged Field
I have a pivotchart which I cause to take a huge list of people's test percentiles and calculate the average for each year. I then display the average above each bar. The problem is that there are too many numbers after the decimal place for each figure. I went into the properties and changed the number format to "fixed" but it doesn't give me the option to change the number of decimal places that are used (it does every where else in MS Office!). It seems that it just uses the regional settings for the computer. But the problem I have in changing that is that I have other pivotcharts in the same report that does something similar but needs a different number of decimal places. Is there any way around this without having to create another query to calculate the average and then having the pivotchart display the info from the new query (this is a huge database that I put together with many charts and I don't want to have to redo the way that it works just because of this decimal place issue)?
View Replies !
View Related
|
TRACKER
