Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old June 4th, 2004, 02:56 PM
Registered User
 
Join Date: Jun 2004
Location: Landfall, MN, USA.
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?
Reply With Quote
  #2 (permalink)  
Old July 8th, 2004, 07:34 PM
Authorized User
 
Join Date: May 2004
Location: Kerhonkson, NY, USA.
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/
Reply With Quote
  #3 (permalink)  
Old July 8th, 2004, 11:04 PM
Registered User
 
Join Date: Jun 2004
Location: Landfall, MN, USA.
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.
Reply With Quote
  #4 (permalink)  
Old July 8th, 2004, 11:08 PM
Registered User
 
Join Date: Jun 2004
Location: Landfall, MN, USA.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I used the Microsoft Office Chart 10.0 active X control.
Reply With Quote
  #5 (permalink)  
Old July 12th, 2004, 09:07 PM
Authorized User
 
Join Date: May 2004
Location: Kerhonkson, NY, USA.
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/
Reply With Quote
  #6 (permalink)  
Old July 12th, 2004, 09:09 PM
Authorized User
 
Join Date: May 2004
Location: Kerhonkson, NY, USA.
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/
Reply With Quote
  #7 (permalink)  
Old June 8th, 2006, 12:58 AM
Registered User
 
Join Date: Jun 2006
Location: , , .
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:)


Reply With Quote
  #8 (permalink)  
Old June 8th, 2006, 12:59 AM
Registered User
 
Join Date: Jun 2006
Location: , , .
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 03:04 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.