Need help getting started 1

[mrdod]

I've created a Safety Database where areas are audited and the results are stored. Each criteria has a number (code) assigned to it (Slippery Floor = 1, No safety glasses = 2 etc..). What I'm trying to do is allow each area audited as well as the whole plant site to view the results for a certain time period. I have never created a chart in Access and am not sure what would be the best route to take. I'm sorry if my question is ambiguous and can supply more information if needed.

Thank you.

 

[dhookom]

If you want to create a chart, first create a query that displays the values you want to chart. Then use the chart wizard (form or report) and use the query as the Row Source for the chart.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[mrdod]

dhookum, Thanks for the response. I'm having a hard time visualizing what the layout will be. My problem is getting the count of the issues (safety risks) that are reported. For example: In 12 months Area x might have 3 - oil on floor, 5 - cluttered area, and 4 - no safety glasses. When I run the report/form/whatever I just want the user to select his/her area and have the infomation in a chart (or a pareto). I've assigned a code for each instance but not sure if it's needed (oil on floor is 4). It sounds easy but I've never had any formal training with Access so it's all googling and this Forum for me. Again any help would be great!!

 

[dhookom]

Can't help you without knowing something about your table structure and data. It would also help if you had an idea how the data should be displayed in a chart.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[mrdod]

Yah sorry about that. I figured out the Query, which was pretty easy after I did some more research about grouping. I tried creating a form that would display the Queried infomration but am having problems. As to your response the information basically looks like this.

Area Audited Issue Occurrences
Office Area Open Food Cont. 3
Machining No safety glasses 10

I have my Query looking like this though there is a date to before Area Audited.

I have a form where the user selects the area, the Query updates, and the form showing the chart appears. I'm not getting any information on the chart for some areas. Obviously I'm not really sure what I'm doing but at this point I'm tinkering with the settings and I'm not really getting anywhere.

Here is the code I'm using:
Private Sub cmdmakechart_Click()

DoCmd.OpenForm "frmmastercharting", acFormPivotChart

End Sub

 

[dhookom]

I don't have any experience with pivot charts. I only create pivot tables and charts in Excel. I create standard charts in Access forms and reports.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[mrdod]

I tried creating a standard chart but couldn't figure out how to format it so I could actually read it. Maybe I need to do some tinkering.

Thanks again.

 

[dhookom]

You might want to consider creating a pivot table/chart in Excel using a linked datasource to your Access query.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[mrdod]

Once again I really appreciate the response. I only want to use Excel as a last ditch effort so please don't think I don't respect your opinion I just really really want this to be one application. I posted the following and since you seem to be really good about responding maybe you could give me some insight? This all centers around the sameproblem.

I have a form (frmmakereport) with a combo box and a command button. The user selects the area he/she wants to view. I have a query that runs Area, Issue, Number Of Issues. In the query (QRYexample) I have the criteria for the Area =Forms!frmmakereport!cbarea.

After the user selects the area to be viewed they push a button where I have a form (frmexample) with an embedded chart pop up. The recordsource is set to the Query (QRYexample). The form never shows up instead I am getting an error saying "The Microsoft Jet database does not recognize 'forms!frmmakereport!cbarea' as a valid name or expression. What exactly am I doing wrong? I'm a super noob as you can probably tell with the number of posts I've put on here with this whole charting thing. Thank you for your time.


Here is the code:
Private Sub Command2_Click()
Dim strarea As String

strarea = Nz(Me.cbarea.Value)
Form_frmexample.chrtarea.charttitle.Text = strarea
DoCmd.OpenForm "frmexample"

Any thoughts?

 

[dhookom]

Normally the Row Source property of a chart is a crosstab query. Without seeing your SQL statement, I can't be sure. However, if it is a crosstab, you must designate the data type of all parameters (forms!frmmakereport!cbarea).

While viewing the design view of your chart row source query, select Query->Parameters and enter:
forms!frmmakereport!cbarea text (or other)


Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[mrdod]

I got it to work and I'm not sure if I did what you recommended as I am unfamiliar with the "lingo" I clicked on Rowsource and clicked on the button to the right of that and typed in Forms!fmrexample!cbarea in the Query that popped up. That worked now the items on on the x <--> axis aren't labeled they names of the issues have been replaced with the name of the area??????

I believe once this is resolved I am done (just need to fit the chart to print nicely). Why would the name of the are replace the names of the issues?

Are you tired of me yet?

 

[dhookom]

You can open the chart in design view and change the === to ||||.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[mrdod]

LOL I have no idea what === or ||| are. I'm just trying to make the Chart using the Chart Wizard and it's a pain in the butt. I'm really strarting to appreciate Excel and it's charting system.

 

[dhookom]

When you have the chart in design view, there should be a couple icons the switch the data view from across to down or something like that.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[mrdod]

I finally got it to work (Not sure I like how the printed version looks but oh well)!! I really appreciate all your help and all your patience. Thank you very much.