Problem with Chart Data....

[irsmalik]

Hello Friends
I am facing problem with getting Correct Data in CHARG.... I am selecting
Combo 1 Company Name
Combo 2 Region Name
listBox Territory Name

when I click Preview button.... Report & its Data is OK.... But when I press CHART button... it is giving me data of whole table. I want CHART data Exactly as shown in Report Preview. Can any body help ?
Please note Territory Name is Multi Select (I copied from Net) It must be Single Select.... but correct CHART Data is first priority.... Demo data base is attached

Thanks

 

[arnelgp]

i added two Queries (zzQuery and qryTerritoryFiltered) which will be used on creating your graph.

 

[irsmalik]

Dear arnelgp​

Thank you so much... I am not very good in vba...... Territory Combo vba was copied from Net....
so I could not understand where is the problem. Once again thank you so much...

One more request..... you already have Chart mdb..... I will be grateful if you plz make a form 3 dependent combos
Company, Region and Territory.... means first select company... its related Region show in Region combo... then Region related Territory show in Territory combo / list ..... but vba should not include in this process...
Hop you will not mind... but vba very difficult for me to understand.... As a Senior Programmer... this will not a big task for you.
Thanks in Advance
irsmalik

 

[arnelgp]

see Form1.
Region combobox gets its data from qryComboRegion.
Territory combobox gets it data from qryComboTerritory.

company and region comboboxes have a Macro on their After Update event (see in design view)
to update the "remaining" combobox/es.

Note that you cannot "multi-select" items in combobox.

 

[irsmalik]

Dear arnelgp.... thanks for help....
When I run this form.... it is giving error message.....
Please see attached picture.
irsmalik

 

[arnelgp]

what version of access do you have?
mine is a2021.

 

[irsmalik]

Sir I am using Access 2007

 

[arnelgp]

try this a2007 db.

 

[irsmalik]

Dear @arnelgp​

Thank you so much.... now its working.... many reports depends on this 3 dependent combos ....
Thanks for spending your time. ...
irsmalik

 

[irsmalik]

Dear mR @arnelgp​

I made a Chart based on a query..... Chart and its data is OK.....
But I want to show Total at Page Header..... Sum([TotalDealers]) is giving Error.
Request to please help...... thanks
irsmalik

 

[arnelgp]

see your chart.
and see the controlsource of the textbox.

 

[irsmalik]

Dear Mr @arnelgp​

=DSum("TotalDealers","Query3")
This is a new thing for me... Sum of Text Field ....

Fortunately,,,,, I want to make my software "Perfect"..... but unfortunately..... I don't have much knowledge of Access / VBA. I always look some one who could help me.....

One more thing, Chart is going to 4 to 5 pages..... Not this one,.... in all pages Data is same .... but chart cover 3, 4, 5 pages.... how to Restrict a chart on One Page ?

Sir Big Thanks.... and very Sorry.... as I take your time..... hoping same spirit from your side in future.
irsmalik

 

[irsmalik]

Here is the mdb containing chart exceeding from one page...
irsmalik