[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.