Wrox Programmer Forums
|
BOOK: Expert One-on-One Access Application Development
This is the forum to discuss the Wrox book Expert One-on-One Microsoft Access Application Development by Helen Feddema; ISBN: 9780764559044
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Expert One-on-One Access Application Development section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 4th, 2004, 02:56 PM
Registered User
 
Join Date: Jun 2004
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default Charts by VBA

I primarily bought the book for the section on exporting to Excel, but really I don't want to export to Excel. I would like to create a chart in VBA within Access.

I see that there is a chart object and a chchart.series.add or something like that. Do you have any examples of charting within Access using VBA? I found an msdn example but mostly oriented toward publishing to a web page. Most examples I see are either not using VBA but demonstrate manually creating the chart or utilizing Excel through automation. Is there anything wrong with doing this within Access?
 
Old July 8th, 2004, 07:34 PM
Authorized User
 
Join Date: May 2004
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Default

MS Graph (or Chart) was used many versions ago; it has since been replaced by PivotTables and PivotCharts, which are much easier to use and more versatile. See Chapter 5 for information on working with these objects in the Access interface. I don't cover creating PivotTables and PivotCharts in VBA code in the book, but it can be done.

Helen Feddema
Kerhonkson, NY
hfeddema@hvc.rr.com
http://www.helenfeddema.com
Read Woody's Access Watch
http://www.woodyswatch.com/waw/
 
Old July 8th, 2004, 11:04 PM
Registered User
 
Join Date: Jun 2004
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I thought with a pivot table you are changing the arrangement of the data like taking row entries and using those as column headings.

I just wanted a regular bar chart. I think I have gotten the charts I want in Access with VBA, now. I found a way to create a trendline by using a constant value as another series, hiding the series bars by making them the same color as the background of the chart and then using the trendline option on that series. Is there a better way? Right now my trendline looks like a dashed line where my camouflaged bars go through it.

I also want to make use of the material in your book on exporting to Outlook because I have a database for creating invoices and currently I just manually create a pdf and then email it, but I have wanted to automate this. I have to finish the charting stuff first but I think I have what is needed.

What I appreciate about your books is the way in which you use forms. I was amazed to see how your forms are so neat and consistent along with being very functional.
 
Old July 8th, 2004, 11:08 PM
Registered User
 
Join Date: Jun 2004
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I used the Microsoft Office Chart 10.0 active X control.
 
Old July 12th, 2004, 09:07 PM
Authorized User
 
Join Date: May 2004
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Default

You are right about PivotTables -- they arrange data in rows and columns. PivotCharts, however, are graphical -- you can create bar graphs, pie charts, line graphs, and more, with all sorts of fancy formatting. They are much easier to work with than the old MS Graph charts.

Helen Feddema
Kerhonkson, NY
hfeddema@hvc.rr.com
http://www.helenfeddema.com
Read Woody's Access Watch
http://www.woodyswatch.com/waw/
 
Old July 12th, 2004, 09:09 PM
Authorized User
 
Join Date: May 2004
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Default

As far as doing invoices with a link to Outlook is concerned, see my Code Sample #29 (on the Code Samples page of my Web site, www.helenfeddema.com). This is my Time & Expense Billing application, which uses custom Outlook journal items to store time worked and expenses incurred for clients, and then produces Word invoices.

Helen Feddema
Kerhonkson, NY
hfeddema@hvc.rr.com
http://www.helenfeddema.com
Read Woody's Access Watch
http://www.woodyswatch.com/waw/
 
Old June 8th, 2006, 12:58 AM
Registered User
 
Join Date: Jun 2006
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi
I ;m not expert a bout your problem but I know a site a bout chart maybe this chart coud help you for solving your problem.
thanks a lot
Zara:)


 
Old June 8th, 2006, 12:59 AM
Registered User
 
Join Date: Jun 2006
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

noe I introduce this link for you(http://www.e-charts.com)
Zara






Similar Threads
Thread Thread Starter Forum Replies Last Post
charts MunishBhatia ASP.NET 2.0 Professional 0 May 28th, 2007 11:52 AM
about charts MunishBhatia ASP.NET 2.0 Professional 1 May 11th, 2007 05:40 AM
Generating Charts with VBA davidimurray Excel VBA 5 September 21st, 2006 08:04 AM
charts s_gh Excel VBA 1 May 31st, 2006 09:53 AM
Reporting Charts Brendan Bartley Access 0 May 29th, 2006 08:50 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.