I use Excel charts all the time. The resource that got me started was the book called Access 2003 Power Programming with VBA by Allen Taylor and Virginia Andersen. Chapter 17 has info on how to interact with other programs and page 502 has some good info.
My colleague also says she has gotten lots of stuff from Allen Brownes site.
The thing that is useful for what I do is chronological charts. I open existing files, run new queries against the data, output the results in to the spreadsheet, and then reset the data source for the chart. Also, the users I have can have OLE to their powerpoint slides so all they have to do click a button, check the results, and go to their meetings with their powerpoints refreshed with the new charts.
Respectfully,
Liz Ravenwood
Programmer / Analyst
B/E Aerospace | Super First Class Environments
1851 S Pantano Road | Tucson, Arizona 85710
Office +1.520.239.4808 |
beaerospace.com
Passion to Innovate. Power to Deliver
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bill Mosca
Sent: Wednesday, July 03, 2013 10:33 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Something better than the chart object
Art
Access charts are absolutely terrible. I've heard some people use Excel charts instead, but I've not seen it done.
As to making changes, I usually end up starting from scratch using the wizard. But if you double-click the area you want to edit you should get a dialog box to help you.
But as I said, I hate them.
Bill Mosca
--- In MS_Access_Professionals@yahoogroups.com, "Art" <dbalorenzini@...> wrote:
>
> Is there something better than using the Access chart object? I have one on my frmDashboard and its a Pie chart but it seems to take for ever to load.
>
> Its was supposed to be based on the following query:
>
> SELECT Count(tblUnit.UnitID) AS [# of Units],
> tlkpClassificationType.ClassificationTypeName AS Class FROM tblUnit
> INNER JOIN tlkpClassificationType ON tblUnit.ClassificationTypeID =
> tlkpClassificationType.ClassificationTypeID
> GROUP BY tlkpClassificationType.ClassificationTypeName;
>
> But when I try and edit it, it pops some sort Excel looking datasheet that I have to edit to get my chart to look right. This chart is supposed to change as the data changes but it seems I have to hardcode the changes. I must be missing something.
>
> Thanks,
>
> Art Lorenzini
> Sioux Falls, SD
>
------------------------------------
Yahoo! Groups Links
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar