Graphing Capacity In Access??

  • Thread starter Thread starter mcl
  • Start date Start date
M

mcl

Is there any kind of graphing capacity in Access like what Excel has? If
there is it sure isn't obvious.
 
Yes, but it is minimal. You can experiment by using the Chart Wizard when
you go to create a New Report. However, for any heavy-duty graphing, your
best bet is to use Office Automation to create graphs in Excel. You'll have
much more functionality. There IS a learning curve, though.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
I'm in the same boat. My users have Office 2003, with Access and Excel.
What's the best way to get started in learning how to integrate Excel's
charting and graphing features with Access?
 
Good question. There's precious little information about Office Automation
out there. The few times I've done it, I've had to scrounge for
information.

Helen Feddema has a few good articles on her site about the Word and Excel
object models. She also has some samples integrating Access and Word
(though sadly, none with Excel or charting). Her site is here:
http://www.helenfeddema.com/.

Google is probably your best friend here. Try searching on: Office
Automation Access Excel. Several links I found were:

http://www.dummies.com/WileyCDA/DummiesArticle/id-2128.html
http://accessvbsql.advisor.com/doc/13667
http://support.microsoft.com/default.aspx?kbid=260410
http://member.advisor.com/doc/04219

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Open Excel. Turn on the macro recorder. Create your chart. Turn off the
macro recorder. Go to macro-edit and you will find the code Excel generated
to create your graph. You can copy and paste it into Access as a starting
point. You will have to modify the code some for it to work in Access.

Before you can run the code in Access though, you will need to open an Excel
instance in Access. Automation does this for you.
 
Unless your reports are particularly complex, Access can handle most tasks.
You may not need to use Excel.

Another option is to use MSQuery in Excel to pull the records you want to
graph. You may not need to have Access open.
 
Back
Top