Need help with chart 1

[sucoyant]

Hello all!

I'm having a bit of a problem with my Access chart. For some reason, when I run the report it will bring up the report with the chart correctly... but then it wants to add a bunch of extra pages after the first. I'm not sure why it's doing this.

I'm guessing it's something in my VB code.

You can download the databases here:

http://www.netphetamine.com/upload/store/help.mdb

<-2k2 Format

http://www.netphetamine.com/upload/store/help97.mdb

<-97 Format

The only 2 employee that have data are: Vicki, Kala
There are other employees, but those are the only 2 that actually have data in the table.

Feel free to DL the database and hack around a bit. I'm not sure what I'm doing wrong.

Thanks in advance!

 

[dhookom]

Change the record source of your report to a totals query that returns only one record per employee:
[blue]

SELECT [Lease Assignment].[Employee] FROM [Lease Assignment] WHERE ((([Lease Assignment].[Date]) Between [Forms]![Menu]![txtLA_PRfrom] And [Forms]![Menu]![txtLA_PRto])) GROUP BY [Lease Assignment].[Employee];

[/blue]

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[dhookom]

BTW: your table is a bit un-normalized but if it works for you then go for it.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[sucoyant]

Excellent. Thank... it's just about there.

The extra pages issue has been solved... but it's still not pulling data for anything but the first employee selected on the list.

If you select Kala and Vicki and run the report, it will only pull the data for Kala.

Any suggestions?

I appreciate your help a lot!

 

[sucoyant]

Any ideas?

 

[dhookom]

A chart/graph control is much like a subform or subreport. To display values/records related to the main report, you must set the Link Master/Child properties to the related field. In your case, that is the EMployee field.

BTW: you could normalize your data with this query:

SELECT Employee, [Account#], [Date], Reviewer, "Acct_paid_off" AS Error,True as IsThisError
FROM [Lease Assignment]
WHERE Acct_paid_off=True
UNION ALL
SELECT Employee, [Account#], [Date], Reviewer, "All_Required_Docs" ,True
FROM [Lease Assignment]
WHERE All_required_docs=True
UNION ALL
SELECT Employee, [Account#], [Date], Reviewer, "Title_signed_correctly" ,True
FROM [Lease Assignment]
WHERE Title_signed_correctly=True
UNION ALL
SELECT Employee, [Account#], [Date], Reviewer, "Correct_docs_prepared" ,True
FROM [Lease Assignment]
WHERE Correct_docs_prepared=True
UNION ALL
SELECT Employee, [Account#], [Date], Reviewer, "Title_sent_correct_party" ,True
FROM [Lease Assignment]
WHERE Title_sent_correct_party=True
UNION ALL
SELECT Employee, [Account#], [Date], Reviewer, "Tax_check_or_filing_fee" ,True
FROM [Lease Assignment]
WHERE Tax_check_or_filing_fee=True
UNION ALL
SELECT Employee, [Account#], [Date], Reviewer, "Charged_correct_GL" ,True
FROM [Lease Assignment]
WHERE Charged_correct_GL=True
UNION ALL
SELECT Employee, [Account#], [Date], Reviewer, "Required_notes_memo_scrn" ,True
FROM [Lease Assignment]
WHERE Required_notes_memo_scrn=True
UNION ALL SELECT Employee, [Account#], [Date], Reviewer, "GoodBad" ,True
FROM [Lease Assignment]
WHERE GoodBad=True;

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[sucoyant]

Thanks dhookom.

When I try to enter anything into the Master/Child link box, I keep getting the following error:

Why is it doing this?

Again, Thanks for your time!

 

[dhookom]

You are probably attempting to use the builder button? Just type Employee into both properties.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[sucoyant]

I tried that... but it didn't fix the report problem.

I'm really confused as to why it's not working...

 

[dhookom]

It looks like your Row Source of the graph control should take care of the Employee link. My graph for Kala and Vicki look fine.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[sucoyant]

Really? You mean when you select both from the list box, and hit the graph button, you can view both graphs without a problem?

For me, when I select Kala and Vicki from the list only one will have data, and the other's graph will be blank.

 

[dhookom]

What dates are you entering? Kala only has data from 1/1 to 1/11 and Vicki from 1/11 to 1/18.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[sucoyant]

I'm putting in 1/1/1 - 9/9/9

 

[dhookom]

You might want to try add this code to your report

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.OLEUnbound0.Requery
End Sub



Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[sucoyant]

Duane,

The employee list box has multiselect enabled. Try selecting Vicki and Kala, then hit the Graph button.
It will only allow you to view one of the employee's data. If you hit the > button in the bottom left hand corner to try to view the next page, it will give you an error.
This is what i'm trying to fix. Any ideas?

I appreciate all of your help!

 

[dhookom]

My copy allows me to select multiple employees and run the report. I can view two pages with no problem.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.