Karl <karl3200@gmail.com> wrote:

>I have some monthly inventory data that I need to create a line chart
>for.

Export to Excel and create the charts there. Seriously. Access charts are quite
limited and a PITA to work with.

Modules: Sample Excel Automation
http://www.mvps.org/access/modules/mdl0006.htm
Modules: Transferring Records to Excel with Automation
http://www.mvps.org/access/modules/mdl0035.htm

You can very likely setup the chart programmatically too. Run the Excel macro
recording function. Create your chart. Then copy and paste the VBA code into Access
and mangle it there.

To start with set a reference to Excel Once you've got the code working with the
nice Intellisense feature change your code to use late binding. Late binding means
you can safely remove the reference and only have an error when the app executes
lines of code in question. Rather than erroring out while starting up the app and
not allowing the users in the app at all. Or when hitting a mid, left or trim
function call.

This also is very useful when you don't know version of the external application
will reside on the target system. Or if your organization is in the middle of moving
from one version to another.

For more information including additional text and some detailed links see the "Late
Binding in Microsoft Access" page at http://www.granite.ab.ca/access/latebinding.htm

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Granite Fleet Manager http://www.granitefleet.com/