Access capability to create report with charts

[SF]

Hi,

I don't know whether it is the right group to ask this question. It is
related to Office automation. My question is whether access has the
capability to provide data to a word report that consist of several tables
and graphs. What I have been doning is export the table to excel first then
manually add these tables and graphs to the report. Could somebody advice/

regards

SF

 

[TC]

All of the Office products can be fully automated - including (but not
limited to) Access, Word & Excel.

So the answer to your question is "Yes".

HTH,
TC (MVP Access)
http://tc2.atspace.com

 

[SF]

Could you pint out the direction that I should start with.

SF

 

[PCD]

Take a look at Pivot Charts to see if they will do what you want. You could
then do everything in an Access report.

 

[Guest]

The question: I dont know If this is the right group. It is related to office
automation. Question is weather access has the capability to provide data to
a word report ?
I dont see why you shouldn't click on tools then merge to microsoft office
and then just create your graphs in word. Am I missing something?
Are you converting to Excel for a special reason?

 

[TC]

What do you actually want to do? You used the term "automation". That
implies, writing program code to manipulate another program. For
example, using automation, you could write program code, in Access,
that would start Word, create a new document, and copy some data from
Access, into that document. Is that the kind of thing you want to do?

HTH,
TC (MVP Access)
http://tc2.atspace.com

 

[SF]

Can access produce a final report in word with formatted heading and table
of contents? If yes, what step should I follow?

 

[TC]

Yes, it can produce a report. As I said before: "Using automation, you
could write program code, in Access, that would start Word, create a
new document, and copy some data from Access, into that document." That
would include, for example, formatting the document, creating an index
& table of contents, and so on.

Here's the code to start Word, from Access, and make it visible:

dim oWord as object
set oWord = createobject ("word.application")
opWord.visible = true
msgbox "Look for Word!"

You'll need to have a good understanding of the "Word object model".
That is the set of objects, methods & properties that you can use, from
Access, to program Word.

Here is the object model for Word 2003:
http://msdn2.microsoft.com/en-us/library/kw65a0we(VS.80).aspx

HTH,
TC (MVP Accvess)
http://tc2.atspace.com

 

[SF]

Thank you. This is a good start for me.

SF