I am not sure where to post this so could someone please move it to the appropriate area thanks.
I want to make a graph that will show how many employees are in the company for each year (Going back 10 years and keeping up to date) I have never done this before and our teacher feels that its best if we learn on our own (basicaly he's an idiot).
How do I go about using the pivot chart?
I have made a query which adds up the total number of employees at the current time.. but apart from that I havent a clue. I want the graph to have the years on the bottom and numbers up the side (1,2,3,4,5 etc) and then the number of employees that were in the company during that year will be plotted.
I will use a table that is to be used for archiving to mke the query as it will have all the employees who were ever in the system record.
The table is thus:
Employee_ID
Emp_First_Name
Emp_Surname
Age
Emp_Home_Number
Emp_Mobile_Number
Emp_Address_1
(so on and including postcode)
Date_Started
Position_ID
I have no idea what to do other than to rename the axes and change the increments, but they are jsut numbers, no dates or anything.
I have created a table in Access with the data I need to put into a line graph.
The data is in this format:
[Table]....
This just a snapshot of the data. What i would like to do is produce seperate line graphs for each town, charting the temperatures over the three years. Because there is so much data i need to find a way which can produce graphs on mass.
I am a bit of a db virgin! So I would appreciate some assistance please. I am trying to display a graph in the form view of a db. The db is comprised of a standard form and table set up but the data comes from a series of linked excel spreadsheets. Basically it is a way of displaying student data for parents evenings at school and I would like a graph to make it the data more visual.
I do not know why this has been so difficult. I have search google and even this forum. There is no clear cut explanation on how to build a button on a form to export a pivotchart to a jpg. Does anyone know how this can be done. please show code.
I have a number of deliverables and want to create a graph for each one, I can get a list of deliverable via a select statement but not sure how to create a graph from that
For example I have this sql statement as the row source for a graph
Code:SELECT Team.TeamLeadName AS Expr1, FormatPercent(Avg(RawData.PercentComplete)) AS CurrentProgressFROM Team, RawDataWHERE (((RawData.TeamLeadNumber)=[Team].[TeamLeadNumber]) AND ((RawData.DeliverableDesc)="RACE Off-the-runs v1"))GROUP BY Team.TeamLeadName;
"RACE Off-the-runs v1" is a deliverable
I had the idea of taking the list of deliverables and iterating through them, for each iteration set the row source for a graph as
Code:SELECT Team.TeamLeadName AS Expr1, FormatPercent(Avg(RawData.PercentComplete)) AS CurrentProgressFROM Team, RawDataWHERE (((RawData.TeamLeadNumber)=[Team].[TeamLeadNumber]) AND ((RawData.DeliverableDesc)="deliverableNAME"))GROUP BY Team.TeamLeadName; where deliverableNAME = the current deliverable in the iteration
The problem is 1)I’m not sure if/how to set the row source with a variable (in this case the variable is deliverableNAME) 2)How would I make sure that each iteration its creating a new graph, rather then just overwriting the existing one. Basically how to have each iteration create a new graph. 3)How would I store these graphs, each one on its own form, can they all be on one form (access seems to limit the height a form to 22 inches)
New user here so apologies if I post in the wrong place.
My colleague and I are trying to put together a database which automates a very time consuming process which is currently being done in Excel.
The purpose of the database is to pull together a load of actuals from SAP and then the forecasts we have put together and then chuck out a whole load of graphs and a summary spreadsheet/ report for the upper echelons;ons of management.
The data is in the database and so far it is all going well - but we have hit a stumbling block. We need Access to calculate some cumulative totals so that we can throw the whole lot into our excel graphs but we can't figure out how to do it.
We are using ye olde Access 97 so our options are a little limited.
Can anyone give us a starter for 10? If you need anything more technical, I can post whatever information you need.
My database records order details for analysis. I have created a form to monitor individual trends in orders placed by my customers. As we supply bespoke items each customer has a list of products which they alone purchase, i.e we do not supply stock items, each item is specifically for one customer (they can then buy the items on a regular basis). The products are assigned to a customer in the products table.
The Analysis form I have created displays the customers name and two graphs. The first graph shows total sales each month, this graph updates as I navigate through the records (i.e. a different graph is loaded for each customer). The form also contains another graph, this is where the problem lies! This graph shows orders of the individual products, controlled by a drop down list containing all the products we supply. I need to limit this list to only show those products relevant to the current customer select on the form. (The products are assigned to a customer in my products table). Currently I achieve this by using a query which when the form is opened asks me to enter a customer ID, the drop down list is then limited to the products supplied to that customer.
What I would like is for the drop down list to update as I navigate through the records. i.e. when customer A is displayed show all the products assigned to customer A, when customer B is displayed show all the products assigned to customer B.
I’ve attached a snapshot of the form to help explain what I mean.
i have a graph in access, and when i print it on a laserjet printer, all of the data and text prints. When i print the graph on a inkjet, only the text prints...not the graph. How do i solve this?
I am about to start a project where I must link an Access front-end database to an Oracle backend. I have about a year of Access development behind me now, and now here is the next challenge.
What I have to do is create analyses of data and output the data mainly in the form of diagrams (i.e. graphs or charts). I have seen how this can be done with Automation in Access in a book by Alison Balter (Mastering Access 2000 Development), by controlling the Excel object etc.
Here are my 2 questions:
1. I am considering buying another book on Access now, something that will contain more examples/methods for presenting information as a graph with the help of Excel. Should I stick to buying an Access book, or should I look into getting something that is more Excel programming oriented, i.e. something like an “Excel programmers compendium”? Any recommendations/tips to get me started would be appreciated.
2. The users want the graphs that I produce to be saved as a .PDF automatically at the push of a button in the Access GUI. How is this done? Do I need special software, or can I use something like PDFWriter to automatically convert the Excel graphs into .PDF’s?
Thanks in advance for the tips and have a nice day! :)
Using Access 2010 32-bit. I have a report that contains a Graph Chart (class = MSGraph.Chart.8). The reports works fine using the uncompiled .accdb. When I compile to .accde, the report is not rendered...I get an empty report screen as though Access is going to produce the report and nothing happens. I have to terminate Access using the "X" at the top right.
I am working on a database used in recording device characteristics/test information. The main table of information has dozens of columns for test/part detailed information. When inputing the data for each specific test, many of the info. details are repeated when testing say 20 devices of the same part all at once. Rather than retype every piece of detailed information in every field, everytime, is there an easier way? Does anyone know of a way to make specific fields copy/paste the previous record's information in the fields automatically when a new record is created? Please, if anyone could help or has ANY ideas, let me know...
On my database I have a text box that accepts a map grid that starts with two letters. If the letters arnt within certain perameters then the box turns red and a message box appears informing the user of this. My probem is that I am using a continuous form and if one box goes red, they all go red if the grids are OK. my code is below, can anyone help?
Private Sub Grid_BeforeUpdate(Cancel As Integer) If IsNull(Me.Grid) Then Exit Sub If Me.Text289 = "UK" Then Select Case Left(Me.Grid, 2) Case "ST", "SY", "SU", "SZ" Me.Grid.BackColor = 16777215 Case Else MsgBox "Invalid Biagram for your chosen Database.", vbExclamation Me.Grid.BackColor = 225 Cancel = True End Select End If If Me.Text289 = "Germany" Then Select Case Left(Me.Grid, 2) Case "MB", "NB", "NC", "MC" Me.Grid.BackColor = 16777215 Case Else MsgBox "Invalid Biagram for your chosen Database.", vbExclamation Me.Grid.BackColor = 225 Cancel = True End Select End If If Me.Text289 = "Desert" Then Select Case Left(Me.Grid, 2) Case "NJ", "NH", "NK" Me.Grid.BackColor = 16777215 Case Else MsgBox "Invalid Biagram for your chosen Database.", vbExclamation Me.Grid.BackColor = 225 Cancel = True End Select End If End Sub
i developed a program and i used ms access for the database. i compiled the program i made. the question is, can i install the program i made into another computer eventhough it doesn't have a ms access? because i tried to install but it doesn't work at all. what do i need to do in order to make it work.
I am having error message when I tried to make my mdb file to mde. The error message is "MS Access unable to create an MDE database". Reading through the help message it says that this problem always occurrs in trying to compile large db into MDE. So what can I do to solve this problem. Also what is MS access memory capacity. thanks
:mad:Is there anyway, I can tell who is making my backups. Is there any thing I can use to find out who is creating a backup. I have sent out emails to the users, but no one will confess who is doing yet. I have 200 users now. I have talk to our IT people, they mention it would take a lot of there time to track it down.
One column is "Unitary Price", another one is "Quantity" and another one is "Tax"
And I want another column called "Total" that shows: Unitary Price*Quantity+Tax*Price*Quantity
Is this possible to be made?? :( I'm a bit newbie to MS Access, so try to explain as most detailed as you can! For example, if I have to write [Unitary Price] between brackets... I tried doing this on the "Default Value" field of the column but I couldn't make it.
I'm trying to make totals in a query, but instead of using all, I need to leave one out, how to do that? for example the table looks like: A 2 3 B 4 6 C 2 5 D 3 5 E 2 3 How can I leave row 1 out? So that the query will look like: 11 19
The MainMenu calls the other 3, when I execute the mde file the only form opened is the frmAddEmployee! it should open the frmMainMenu because this one calls the others....! I've tried several times....the same result!
