[AccessD] How to Change an Access 2007 Chart with VBA Code

All,

I found an example and am now on my way to "Chart-o-Rama" with Access :-)

There is still one thing that I don't quite understand.

It appears that a person can generate Charts directly in Access or use Windows Automation to control Excel from Access (to create and modify charts).

Is one approach better or more widely used than the other?

Thanks,
Brad

  



 


-----Original Message-----
From: accessd-bounces at databaseadvisors.com on behalf of Brad Marks
Sent: Fri 2/17/2012 7:11 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] How to Change an Access 2007 Chart with VBA Code
 
William,

Thanks for the help.

Earlier today, I had actually tried the example in this code.

It is too complicated for me at this point.

I could really use an example of how to change just one thing, such as the Chart Area color.  

Once I have an example, I believe that I could learn from it and build on it.

I am also confused about what References (if any) I will need.

Thanks again,
Brad     


-----Original Message-----
From: accessd-bounces at databaseadvisors.com on behalf of Benson, William (GE Global Research, consultant)
Sent: Fri 2/17/2012 6:56 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] How to Change an Access 2007 Chart with VBA Code
 
Brad,

Some code here:

http://msaccesstips.com/2008/06/working-with-chart-object-in-vba/

I didn't try it!

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Friday, February 17, 2012 7:32 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] How to Change an Access 2007 Chart with VBA Code

All,

I am trying to learn how to change an Access 2007 Chart with VBA code.

I have a test Access application with one report (Report1).  This report has one Chart (Chart1).

I now would like to experiment with changing Chart1 with VBA code.

Does anyone have an example of how to do this?

I have done quite a bit of digging and I must be missing something.

Thanks,
Brad


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.



-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.